Skip to main content
Inspiring
Aug 5, 2024 3:05 PM UTC
Solved

Querying record and display result in read only grid

I am querying one record and aggregating two fields name and hobbies.I want to display all the hobbies in a single cell for a name ,in a single row in the read only grid.For Example

Name Hobbies
Ram

Playing

dancing

cooking

Please help with this,how to achieve this example

    stefanhelzle0001
    Brainy
    Aug 5, 2024 3:15 PM UTC

    Can you share the data structure you get?

    4 replies

    stefanhelzle0001
    Brainy
    Aug 5, 2024 3:15 PM UTC

    Can you share the data structure you get?

    Inspiring
    Aug 5, 2024 3:38 PM UTC

    Hi [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] ,Currently I am getting data like this

    but I want to display only one row,which will have jurisdiction as 44 and all the three line of business in a single cell of column Line of Business

    Inspiring
    Aug 5, 2024 3:41 PM UTC

    I am querying a record for getting these two field jurisdiction and line of business

    venkatrea696188
    Inspiring
    Aug 5, 2024 4:06 PM UTC

    Is jurisdiction and Line of business are coming from same record or do you have relationships? If both are coming from same table you need to group it before/after querying (Important part of your requirement). For showing it on screen you can simply use looping and line spacing ,it's not big of deal .