topic Re: Search String Format in App Development

Search String Format

MallikarjunaG — Mon, 22 Sep 2025 09:44:54 GMT

Hi All,

I have scenario like data values are like

ProdA|ProdB

Prodc|

ProdE|ProdE

I am providing input box for users to paste the list of values into input to search through column through button action

I was able do it if the column value is having single value , but the same search string format not working for above data format, knidly help me with search string format to be used in button action

Thanks & Regards

Mallikarjun

Re: Search String Format

robert_mika — Mon, 22 Sep 2025 09:53:12 GMT

1. Use a expression to split string into single inputs

2.Create then action using the option 'Select values matching search criteria'

with a sting like ='(" ' Product('$(vProd1)')&'"|"'&Product('$(vProd2)')&' ")'

Re: Search String Format

Chanty4u — Mon, 22 Sep 2025 17:41:55 GMT

Try this

You can use

LOAD

ID,

SubField(ProductField, '|') as Product

FROM Source;

So that you can use normal search.

Try this

*$(vInputValue)*

Re: Search String Format

MallikarjunaG — Tue, 23 Sep 2025 15:13:51 GMT

Hi Both,

have to use both of your inputs to make it work,

Thank you for your help

Regards

Mallikarjuna