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