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:
Similarly, a query to filter on incidents created in last 30 days (queries from table):
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:
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
Post a Comment