Solved

Querying record and display result in read only grid

Forum|Forum|1 year ago
August 5, 2024
4 replies
0 views

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

Best answer by stefanhelzle0001

Can you share the data structure you get?

stefanhelzle0001Answer

Brainy

Can you share the data structure you get?

M

mohiniv1048Author

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

M

mohiniv1048Author

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

venkatrea696188

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 .

Sign up

Login with SSO

Login to the community

Login with SSO