Expression table grouping

Posted by: tuanlb2311 on 25 October 2021, 5:49 pm EST

  • Posted 25 October 2021, 5:49 pm EST

    I have an object { level1: “sort1”, level2: “sort2” } with sort1, sort2 being the mutable input I used “Table grouping” in ActiveReportsJs tool to sort the data group. I see that the expressions section in the ActiveReportsJs tool only supports static variables. For example: { Sort1 } I tried to make it a dynamic struct by passing values corresponding to each sort level For example expression group one: {Switch( level1 = “Sort1”, “{Sort1}”, level1 = “Sort2”, “{Sort2}” )} expression group two: {Switch( level2 = “Sort1”, “{Sort1}”, level2 = “Sort2”, “{Sort2}” )} It didn’t work as expected. Looks like it was not supported. Could you please take a look and let me know if you have any suggestion? Thanks.

  • Posted 26 October 2021, 6:37 pm EST

    Hello, I think that the correct syntax for such an expression would be:

    {Switch(level1 = "Sort1", Sort1,level1 = "Sort2", Sort2)}
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels