Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Combined attribute search with NullSearchConstraint on MDM 5.5 and Java API

Hi everyone,

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.

Search Parameter:

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?

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question