Looking for sample code similar to...

Hi all,
I want to build a report similar to the support case report (forum.appian.com/.../P8Bjfg).
Does anyone have sample code for someting like this?
TIA, Moritz

OriginalPostID-219577

OriginalPostID-219577

  Discussion posts and replies are publicly visible

Parents
  • @moritzw To the best of my knowledge it isn't possible to do. In order to overcome this, one option could be saving month and year as separate fields, and the other is, writing a Database View which will return the data in desired manner without a need of adding and populating new fields and I would personally prefer this. I believe the forum post at https://forum.appian.com/suite/tempo/entry/e-202703 outlines the approach of using a View with an example and off-course you can find some more if you make a search through. You can also plan for a similar approach if you are planning to report on analytics data.
Reply
  • @moritzw To the best of my knowledge it isn't possible to do. In order to overcome this, one option could be saving month and year as separate fields, and the other is, writing a Database View which will return the data in desired manner without a need of adding and populating new fields and I would personally prefer this. I believe the forum post at https://forum.appian.com/suite/tempo/entry/e-202703 outlines the approach of using a View with an example and off-course you can find some more if you make a search through. You can also plan for a similar approach if you are planning to report on analytics data.
Children
No Data