How to ignore null values of a record while fetching from the database

Certified Associate Developer

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

                                            Discussion posts and replies are publicly visible

                                          Parents Reply Children
                                          No Data