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)

Question

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.

Sanchit Gupta (Xebia) · Accepted Answer

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.

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)

Top Replies