Skip to main content
vinodn0005
vinodn0005
October 7, 2021
Question

Query output

  • October 7, 2021
  • 6 replies
  • 0 views

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?

    6 replies

    mikes0011
    mikes0011
    Brainy
    October 7, 2021

    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?

    The Expression Guru
    vinodn0005
    vinodn0005Author
    October 7, 2021

    Yes [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] Data is stored in the mentioned manner and while fetching a data I need to apply queryfilter to get intended data to UI

    mikes0011
    mikes0011
    Brainy
    October 7, 2021

    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.

    The Expression Guru
    peter.lewis
    peter.lewis
    Employee
    October 7, 2021

    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?

    vinodn0005
    vinodn0005Author
    October 7, 2021

    Not exactly the same data but which included column data

    peter.lewis
    peter.lewis
    Employee
    October 7, 2021

    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?

      Terms & ConditionsAccessibility statement