Skip to main content
kavyam0002
kavyam0002
May 19, 2022
Question

filter

  • May 19, 2022
  • 5 replies
  • 0 views

Hi,

am querying data from db, in that one col name as row_type will will have multiple values- like approved, proposed, out_standing 

i want to fetch approved and proposed data and show those values in different columns in UI 

i have to show approved row data in approved limit and proposed rows in allocated limit 

can anyone help with this

    5 replies

    gopalk2865
    gopalk2865
    Participating Frequently
    May 19, 2022

    HI Kavya, It depends upon your data coming from entity. Probably you would need to manipulate with the data and structure it according to your requirement. without seeing actual data , We cant provide you the logic.

    N
    nareshs945
    May 19, 2022

    As Gopal mentioned It is hard to understand your question. If you can provide a sample result data so that we will try to provide a solutions

    kavyam0002
    kavyam0002Author
    May 19, 2022

    this is how data base data 

    approved row data in approved col and proposed values in allocated col 

    gopalk2865
    gopalk2865
    Participating Frequently
    May 19, 2022

    Hi Kavya, You can write your query entity  with filter like below,

    a!queryFilter(
field:"ROW_TYPE",
operator:"in",
value:{"Approved","Proposed"}
)

    Terms & ConditionsAccessibility statement