I want to know how can i search for multiple names separated by "comma" or "and".
Please show me step by step how to do it.
Hi hind Ahmed,
Do you want type names separated by comma in text box and then search?
Please elaborate your use case.
Thanks and Regards,
You are going to need to parse the search string and use it to construct a WHERE clause to pass to an Advanced Quesry as a paramter. Set that parameter's "Expand Inline" property to the opposite of whatever the default setting is (I always forget which is which).
So, you'll do something like:
I think justin suggetion(use String_Split on the result to split on commas and iterate over the result, to slowly build up a WHERE clause in the form of "WHERE Field LIKE '%Value%' OR) will fullfil hind`s requirement.
Suraj Borade wrote:
Yah i want to type the name separated by comma or the "AND" in text box and then search.
either comma or the "AND" or both its fine.
Could you help me please and show me how to do it step by step?!
Justin James wrote:
I think i am lost where do i have to start to "Make the search string all lowercase" ?!
thanks for the help but how can i start building the search with comma or AND while i have the search function
can you please explain in details so i can catch up
This comes up enough that I put together some sample code: