Hi I have this code written
local!productgroup: a!queryEntity( entity: cons!MPPCONSCDT_megaMasterFile, query: a!query( /*selection: a!querySelection(*/ /*columns: {*/ /*a!queryColumn(*/ /*field: "productline",*/ /*alias: "productline",*/ /* */ /*)*/ /*}*/ /*),*/ aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "EOMYear", alias: "EOMYear", isGrouping: true() ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1 ) ), fetchTotalCount: true ).data,
I returns below result
Is there any way I can remove the null one?
Discussion posts and replies are publicly visible
You have a couple of choices:
a!localVariables( local!myList: { 1, 2, 3, null, 4, 5 }, fn!reject(fn!isnull, local!myList) )