Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ladislav
Contributor III
Contributor III

Limit search object results by set analyzes

Hi,

I have couple of different data sources in my model. Financial, Sales, Product. They all use a bit different country names.
I have only one 'CountryName' field and therefore those results mix up. When I use search object I get 3 results for single search string.
I can easily resolve it using set analyzes, (limiting data source) in other objects but there is no way to use set analyzes for search object fields, is it?

Thanks

13 Replies
stigchel
Partner - Master
Partner - Master

You can maybe build a custom 'search box', it is a work around and does not completely work as a search box, but...

Add an input box where the user can enter the search string in a variable e.g. vSearch. Then make a listbox where you use an expression like

Aggr(Only({<FACTYPE_ID='A', MySearchField={'*$(vSearch)*'} MySearchField),MySearchField)

ladislav
Contributor III
Contributor III
Author

Perfect that helped. When FACTTYPE_ID is locked and I uncheck 'include excluded' the search results are clear.

Thanks a lot Marcus!

ladislav
Contributor III
Contributor III
Author

Thank you Sergey!

ladislav
Contributor III
Contributor III
Author

Good Idea too.

Thanks