Question
How to ignore null values of a record while fetching from the database
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
- Phase_Solution_Impact""(Text)
- Length_Solution_Impact""(Text)
- valveClosureAdvisory""(Text)
- operatingCondtionAdvisory""(Text)
- flowRateAdvisory""(Text)
- fluidPropertyAdvisory"Mixes of various fluids in the pipeline may impact distance and quantity calculations up to %10 if product separation occurs, or if chemicals are treating mixed fluids in the line"(Text)
- fluidTypeAdvisory""(Text)
- pipelineMaterialAdvisory"Hoses may result in reduced signal strength and survey range"(Text)
- leakCharacteristicsAdvisory""(Text)
- systemAdvisory""(Text)
- tiePointAdvisory"Subsea connections will require additional support equipment for successful operation"(Text)
I want to remove null values from the above result
