Multiple condition in a query to filter data from a global list
I have 5 fields in a custom form, those are division, category, subcategory,type and subtype.
Division is a drop down menu and has value hardcoded in the form designer.
Category is a comfill mapped with the category attribute in cm3rcat table and the data is filtered related to the division selected. For the additional query is defined in link.
Subcategory is also a comfill mapped with the subcategory attribute cm3rsubcat table and the data is filtered realted to the category selected.
Type is a dropdown menu mapped with the type attribute of another table(called as changeModel).
To get the data in type field I have created a global list mapping the field:type and file:changeModel
In 'fd' for my custom form, for the field "type" I have filtered the data related to only subcategory by defining the Value list Condition >select("type","changeModel","subcategory",[custom_form_subcat]), where custom_form_subcat is the attribute for subcategory field in my form. I want to filter the data in type field, related to category and subcategory both.
Lets say, Category:Application Services and Subcategory:Application has type:Test1
Again say, Category:Software and Subcategory:Application also has type:Test2
So whenever, I choose category as Software and subcategory as Application in my custom form, the type shows two data Test1 and Test2
The same thing happens when I choose category as Application Services and subcategory as Application.
If only I could defined a condition where I can filter the "type" data by quering both "category and subcategory"
Re: Multiple condition in a query to filter data from a global list
Maybe we dont understand each other , but what do i mean , if you have a unique set of the selectable parameters then you should not have duplicates, if they are not unique , then it is normal to have some duplicates as in fact they are result of the select