Expression table grouping

Expression table grouping

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

• 

  tuanlb2311

  • Post Options:
  • Link
    Copy

  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.

• 

  sergey.abakumov

  

  • Post Options:
  • Link
    Copy

  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)}