Filters

How can I filter on "system_number" not equal to "PDC*" and "state" equal to "DRMO" OR "Inactive" ///<SUMMARY> ///On select new delivered component as relationship, filter by System not equal to "PDC*" and  State equal to "DRMO or InActive" ///</SUMMARY> var retObj = new Object(); retObj["system_number"] != { filterValue: "PDC*", isFilterFixed: true }; ****** Need to make not equal to" ****** retObj["state"] = { filterValue: "DRMO", isFilterFixed: true };  ****** Need to include "InActive" ****** return retObj;
Parents
  • Hi Chris, For some reason the "is not" condition is acting the opposite, it's showing just PDC. My code is below, any help would be appreciated. TY   inArgs.QryItem.loadXML("<Item type='MIN_Delivered_Component' action='get' page='1' pagesize='25' maxRecords=''><system_number><Item type='MIN_System' action='get' select='id'><keyed_name condition='not like'>PDC%</keyed_name></Item></system_number><OR><state>DRMO</state><state>Inactive</state></OR></Item>");
Reply
  • Hi Chris, For some reason the "is not" condition is acting the opposite, it's showing just PDC. My code is below, any help would be appreciated. TY   inArgs.QryItem.loadXML("<Item type='MIN_Delivered_Component' action='get' page='1' pagesize='25' maxRecords=''><system_number><Item type='MIN_System' action='get' select='id'><keyed_name condition='not like'>PDC%</keyed_name></Item></system_number><OR><state>DRMO</state><state>Inactive</state></OR></Item>");
Children
No Data