Related lists using relationship

Criteria:

on the problem form, display incidents with the same call catgories



applies to table= problem (the form on which the related list appears)
queries from table= incident (the table containing the related records)

script:


current.addQuery('category',parent.u_category);
current.addQuery('subcategory',parent.u_subcategory);
current.addQuery('u_subcategory_2',parent.u_subcategory_2);

parent is the applies to table, field to query is the queries from table


Adding the following 'active' query would apply to the 'queries from' table:

current.addQuery('active','true');


Similarly, a query to filter on incidents created in last 30 days (queries from table):


current.addQuery('sys_created_onONLast 30 days@javascript:gs.daysAgoStart(30)@javascript:gs.daysAgoEnd(0)');

Comments

Popular posts from this blog

Running transform maps asynchronously

Post a command to the ECC queue for the mid server to initiate a powershell file copy

GlideRecord setValue