Skip to main content
raghavak0001
raghavak0001
May 16, 2024
Question

grouping duplicate reords and need to populate latest record

  • May 16, 2024
  • 3 replies
  • 0 views

hi 

in the abov out put only role tasks were diffrent  so  my requrement here is i want the out put -------  group by comment_id ORDER by created_on DESC.

    3 replies

    karumurua531442
    karumurua531442
    May 16, 2024

    Hi [mention:665a63c257a341ceac19f1c4bf214453:e9ed411860ed4f2ba0265705b8793d05] is the data is coming from view? yu wanted to do it from db side or Appian side ?

    raghavak0001
    raghavak0001Author
    May 16, 2024

    data is comming from Sp from third party --post grace sql but group by restrictions are there in postgrace so bry creating view we are fectiching data want to group by  in appain and populate the latest records on the screen 

    venkatrea696188
    venkatrea696188
    May 16, 2024

    I never tried it but sortinfo function might help. Try Converting it into Data subset and in use sortinfo()

    Terms & ConditionsAccessibility statement