How to search qualified lookup table with specified field?

[former_member377357]

Hi,all

I used a srm-mdm catalog and made some customizing fields in price information table.As shown in attached figures,I added the period of validity and obsolete flag to table Price.In MDM Data Manager, I want to search records with price information and filter values in the period of validity

I should search table Price for valid price data first,then the main Catalog Items records.But search parameters for price information not contain the specified customizing fields,only a whole price line can be filtered.

How can i view records in Catalog Item with valid price information with condition info: record start date < system time < info record end date & info record obsolete flag equals FALSE,so that i can make it a named search for the catalog web?

[anita_lipovics]

Hi,

I cannot see your attachment, so please check whether the added fields are qualifier or not (in the MDM Console, Field detail). If the new field is a qualifier you can see it in the Free Form Search in the Data Manager in the Price Infromation Tree. Here you can set your search parameters and save the named search.

Regards,

Anita

[former_member377357]

Hi, Anita

I can search in the Price Information Tree in Data Manager Free Form Search after I set the fields qualifier in console. But the problem is, data in Data Manager contain both data without info record in price information and with info record in price information but partly valid ones. I want to search both of the two, and do not want to view the invalid lines in price information from the main table. In a word, I just don't want to view the invalid price information lines in Price table, and not release the link to the main table record. I'm wondering if that is possible. Could you give some suggestions, please?