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.
  • Replied 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