HI Team ,
I have a requirement where i have query a data from DB
in that one of the column returning a data like this "abc;abc;dfg;vbn" I need to apply a filter on this can anybody suggest how can i achieve this?
Discussion posts and replies are publicly visible
Can you clarify, is the data stored in the DB literally like "abc;abc;dfg;vpn" (etc), i.e. semicolon-separated strings all concatenated together into one string value? What do you mean by "apply a filter"? What is the filter intended to do, precisely?
We would need some more information to be able to help you. What kind of filter do you want to apply? Are you looking for an individual item (e.g. "abc") or filtering on exactly that string? Can you provide more context on what your use case is?
Yes Mike Schmitt Data is stored in the mentioned manner and while fetching a data I need to apply queryfilter to get intended data to UI
Not exactly the same data but which included column data
Yes, I understood originally that you wish to apply a filter - but I was asking what exactly you need your filter to do. In specifics.
I'm sorry I still don't understand. Are you trying to run a filter where the value is exactly "abc;abc;dfg;vbn"? Are you trying to run a filter where "abc" is somewhere in the result? How is the data being used?