Skip to main content
May 30, 2023
Solved

Error while using Export Data Store Entity To Excel : Either selection or filters are invalid: The field [XYZ] does not exist. (APNX-1-4505-009)

  • May 30, 2023
  • 3 replies
  • 0 views

I am using Export Data Store Entity To Excel smart service to export the data from a table to excel file.

When I export everything from the table it works well, however when I use Selection

= a!querySelection(
  columns: {
    a!queryColumn(
      field: pv!exportData.TechSpec,
      alias: "Tech_Spec"
    ),
    a!queryColumn(
      field: pv!exportData.Preservation_Demand,
      alias: "Preservation_Demand"
    )
  }
)

I get this error below :

Please help me with it.

    Best answer by sanchitg0002

    Well, the error message is pretty clear. The value you are passing in field is not a valid fieldName but is some value stored in pv!. Check the CDT and pass the valid field name in string.

    3 replies

    May 30, 2023

    Well, the error message is pretty clear. The value you are passing in field is not a valid fieldName but is some value stored in pv!. Check the CDT and pass the valid field name in string.

    May 30, 2023

    Worked,Thanks!

    harshitb6843
    May 30, 2023

    Also, I would advice to isolate the a!querySelection in a separate expression rule so you don't update the PM everytime you want to make changes in it.