Skip to main content
B
balajib2826
December 4, 2024
Question

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

  • December 4, 2024
  • 2 replies
  • 0 views

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 

2 replies

stefanhelzle0001
stefanhelzle0001
December 4, 2024

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.

prasantap0900
prasantap0900
December 4, 2024

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
          )
        )
      )
    )
  )
)

Terms & ConditionsAccessibility statement