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
  • Hello, On further testing, I'm not sure this direct insertion of AML will work for your use case of trying to use the NOT condition. Simple Searches don't support the 'not like' condition, so it seems your criteria of 'PDC%' is being interpreted by the simple search as using the 'like' condition by default. This would still be possible by using my first suggestion of performing a query within the onSearchDialog event and creating a list of valid IDs to pass in to the search dialog. Chris
    Christopher Gillis Aras Labs Software Engineer
Reply
  • Hello, On further testing, I'm not sure this direct insertion of AML will work for your use case of trying to use the NOT condition. Simple Searches don't support the 'not like' condition, so it seems your criteria of 'PDC%' is being interpreted by the simple search as using the 'like' condition by default. This would still be possible by using my first suggestion of performing a query within the onSearchDialog event and creating a list of valid IDs to pass in to the search dialog. Chris
    Christopher Gillis Aras Labs Software Engineer
Children
No Data