Combined attribute search with NullSearchConstraint on MDM 5.5 and Java API
I have a main table "Products" with a taxonomy table "Main_WI_Classification".
Example of my tables:
No Main_Material_Number (main) Main_Article_Name (main) attribute1 (taxonomy) attribute2 (taxonomy)
1 1812190000 'SL-SMT 5.00/19/90G 3.2' Yes YNY
2 1812000000 'SL-SMT 5.00/19/90G 3.2'
3 1812200000 'SL-SMT 5.00/19/90G 3.2' Yes
I use a search with 3 search parameters, the first parameter is for a field in the main table ("Main_Article_Name") and the second and third parameter is for two attributes ("attribute1" and "attribute2") in the taxonomy table.
As ComparisonOperator I use the AND-operator.
I want to get the third article as result.
1. Main_Article_Name = "SL-SMT 5.00/19/90G 3.2"
2. attribute1 = "Yes"
3. attribute2 = NULL
When I perform the search with all 3 search parameters set, it delivers no results.
When I perform the search with the first and second search parameters set, it delivers 1 and 3.
When I perform the search with the first and third search parameters set, it delivers 2 and 3.
How can I combine the search parameters to work on both attributes to deliver me the third article?
Or is there another way to search for Null Values in attributes of taxonomy tables?