Syntax for outstatistics in Query Layer with variable

Belinda Kerr

April 29, 2021 08:00

Hi,

 

I have a query layer activity and I need to generate outstatistics.

 

If I put a value of

 

=`[{'statisticType':'sum','onStatisticField':${$fieldWasteTypeCnt.result},'outStatisticFieldName':'TruckLoadTotals'},{'statisticType':'count','onStatisticField':${$fieldWasteTypeCnt.result},'outStatisticFieldName':'TruckLoadCount'}]`

 

it turns the result into a string and then the query won't run. If I hard code the onStatisticField to the field I want to use it works. The field changes however so I want to use a variable. What am I missing with this syntax? How do I get the query layer activity to work where the onStatisticField changes without hard coding it? Any ideas with syntax?

0

• 

  Belinda Kerr

  April 29, 2021 08:02

   

  This is what the incorrect syntax looks like..The quotes around the [] need to go so it will run.

  0

Please sign in to leave a comment.