a!queryEntity( entity: cons!ITS_PQR_REQUEST_DSE, query: a!query( selection: a!querySelection( columns: { a!queryColumn(field: "phaseAdvisory", alias: "Phase_Solution_Impact"), a!queryColumn(field: "lengthAdvisory",alias: "Length_Solution_Impact"), a!queryColumn(field: "valveClosureAdvisory"), a!queryColumn(field: "operatingCondtionAdvisory"), a!queryColumn(field: "flowRateAdvisory"), a!queryColumn(field: "fluidPropertyAdvisory"), a!queryColumn(field: "fluidTypeAdvisory"), a!queryColumn(field: "pipelineMaterialAdvisory"), a!queryColumn(field: "leakCharacteristicsAdvisory"), a!queryColumn(field: "systemAdvisory"), a!queryColumn(field: "tiePointAdvisory"), } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "pqrRequestId", operator: "=", value: ri!pqrRequestId ), }, ignoreFiltersWithEmptyValues:true() ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50) ), fetchTotalCount: false ).data
result
I want to remove null values from the above result
Discussion posts and replies are publicly visible
Use "not null" as an operator.