Hiii, i want to fetch multiple string value seperated by semi colon through query in one column like (123456;234565;456789;234567;124567). How we can do that
Discussion posts and replies are publicly visible
I am not sure what exactly you mean with "multiple string value seperated by semi colon through query in one column" ?!?
But you can use joinarray() to merge a list into a string with a separator of choice.
I have two Id one I'd is integer one is string if user select multiple integer Id and string Id either integer value or string value on the basis of that filter in the export to excel value should come so I have made SQL query rule for that for this selection how we can do through SQL in appian
Like this( Id('234','456')OR Id2('234.X.1','3456.C.1')) and same rule input is using for both id