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;
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>");
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>");