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