Need a collapsible link on data filed on clicking that relavant data rleated to particular date show show in a grid

Question

I got a requirement that i have a data from db record 12800 i am using filter to filter the environment type that grid contains id, data, task,count,environment in that grid date is initall scatteered like 24-02-2024 00:00 and in another row 24-02-2024 10:00 like that i want all similar date should be in in single date and need a link near to that date filed on clicking that it should show time along with particular date and tasks enviromnets and other related data to that date field can anyone help me on that

Stefan Helzle · Answer

I have a hard time understanding what exactly you are looking for. If you want to aggregate rows by the date while ignoring time, you could use a custom record field to just extract the date and then aggregate on it when querying the data. A link could then allow the user to show more details for that given date.

Prasanta Paul · Answer

You can do like that. It's an example. a!localVariables(
 local!data:{"Date : 04/12/2024"},
 local!save : 0,
 a!richTextDisplayField(
 value: a!richTextItem(
 text:if(
 local!save = 0,
 left(local!data, 5),
 local!data
 ),
 link: a!dynamicLink(
 value: local!save,
 saveInto: if(
 local!save = 0,
 a!save(
 local!save,
 1
 ),
 a!save(
 local!save,
 0
 )
 )
 )
 )
 )
)