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.
Discussion posts and replies are publicly visible
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.
Worked,Thanks!
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.