Search&Select prompt find exact match

[Commander Cognos]

Hi,

is there a way to find the exact string in a search&select prompt the user is typing in?
Example:

Item no
23
2345
2346

Once the user is searching for "23" only the item "23" should be displayed. It seems that Cognos is querying internally always for like or contains. All existing options are not working and I do not see a way to edit the query.

Thanks and cheers,
CC

[ThatKingslayer]

Look at your Search and Select box (viewing the report in HTML / not in design mode) and you should see options for how the search will work such as 'Starts with any of these keywords' or 'Contains all of these keywords'. That might help. I'd also check your query to see what the filter is set up is like.

One thing though is that you said you were not able to edit the query. Are you in REPORTING or DASHBOARDS? If you meant Dashboards then you might need to move this topic over there as the answers might differ.