Hi have this error message: Expression evaluation error at function 'ty

mokhtarc over 9 years ago

Hi have this error message:
Expression evaluation error at function 'typeof' parameter 1 [line 38]:
Don't see why, it was working well until today.
=load(
           local!data: queryrecord(
                    recordType: cons!ETDE_RECORDCATMATCHING,
                    query: a!query(
                     aggregation: a!queryAggregation(
                              aggregationColumns: {
                               a!queryAggregationColumn(
                                        field: "typematching",
                                        alias: "typematching",
                                        visible: true,
                                        isGrouping: true
                               ),
                               a!queryAggregationColumn(
                                        field: "libellestatut",
                                        alias: "libellestatut",
                                        visible: true,
                                        isGrouping: true
                               ),
                               a!queryAggregationColumn(
                                        field: "quantite",
                                        alias: "quantite",
                                        visible: true,
                                        aggregationFunction: "SUM"
                               )
                              }
                     ),
                     filter: if(isnull(ri!idprojet),null,a!queryFilter(field: "idprojet", operator: "=", value: ri!idprojet)),
                     pagingInfo: a!pagingInfo(
                              startIndex: 1,
                              batchSize: -1,
                              sort: a!sortInfo(
                               field: "typematching",
                               ...

Discussion posts and replies are publicly visible

0 mokhtarc over 9 years ago

... ascending: true
                              )
                     )
                    )
           ).data,
           local!categories: if(isnull(local!data),{},union(local!data.typematching, cast(typeof(local!data.typematching), {}))),
           local!series: if(isnull(local!data),{},rule!ETDE_COLUMNCHARTSERIES(
                    data: local!data,
                    categoryField: "typematching",
                    labelField: "libellestatut",
                    datapointField: "quantite"
           )),
           a!barChartField(
                     categories: local!categories,
                     series: local!series,
                     showDataLabels: true(),
                     showLegend: true(),
                     label: "Patrimoine matché",
                     stacking: "NORMAL",
                     showTooltips: true()
           )
)

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mokhtarc over 9 years ago

The problem comes from the isnull(local!data) that doesn't work anymore. Instead I used length(local!data)=0
Cancel
Vote Up -1 Vote Down

Sign in to reply

Verify Answer

Cancel