Query regarding Data Manager Free Form Search

[Former Member]

Hi Experts,

If we have a lookup field where the underlying lookup table has multiple fields as display fields then we are not able to search on that lookup field using the free form search by entering the values of individual display fields, in order, separated by a comma and a space. When such a search parameter is entered zero (0) records are returned. Even copying the value from the lookup field and pasting into the search box doesn’t return any results.

Is this the correct and expected behavior?

In many cases, multiple display fields together uniquely identify the lookup record. In case the search tab is disabled for such a lookup field, then it is impossible to perform such a search.

We are currently at 7.1.08

Regards,

Ganga

[former_member196156]

HiGanga,

click the black triangle of the lookup field in the Freeform search, by clicking this you will get the list of display fields of the relevant table as shown in the below steps.

step 1:

step 2:

Regards

Rahul

[Former Member]

Hi,

This suggestion is not working for us.

Regards,

Ganga

[former_member196156]

Hi Ganga,

Sorry for the confusion, actually the proposed solution is for lookup main and for tuple field.

You can achieve this by using keyword search, you may be noticed there is field available that is keyword where you can give the values of those fields whose keyword is "Stemmer".

So choose stemmer for the lookup field in the main table and copy the lookup field value and paste in the keyord field of free form serach after this you will be getting the relevant result.

For more information refer Data Manger Refrence Guide.

Regards

Rahul