This article focuses on how to load only those set of records in the list view that are explicitly defined on base-tables.


For each base table, there is a column/field/dictionary called sys_class_name that shows the table name for each record created:

  • This field shows the name of the table where this record is defined (on child table or parent table or base table).
  • This field can act as a key for filtering the records.

The following example demonstrates this:

  • Create before-query business rule on a table let's say, task with the following script:
    (function executeRule(current, previous /*null when async*/) {
    // Add your code here
    current.addQuery('sys_class_name', 'task');
    })(current, previous);
  • The above script will show only those records that are explicitly created at task table (filtering out records from incident, problem, etc.)
  • One caveat here is that this will not just impact the list view (of task table) but on all aspects through which this table is queried.

You can also create a default filter that will run whenever the list is loaded.

Applicable Versions

Jakarta, Kingston and London.

Additional Information

This is kind of a custom behavior and it all depends on respective data integrity. It will break otherwise.

Set a predefined filter as result:

Default before-query business rule:

Instance Customization FAQs and Guidelines:

Article Information

Last Updated:2019-08-02 20:59:00