HI All,
Seeing below error when i try to export DSE to Excel.
Background: We have a UI and we use a CDT to pass the filters into PM to call the DSE to Excel Smart Service. When we try to export without any filters I was able to export the date(16000 Rows), but when I use a created by filter which which returns (8000 Rows), I'm seeing the above error in PM.
Below is the query filter logic
a!queryFilter( field:"referralCreatedBy", operator:"=", value:ri!xxxxx.createdBy, applyWhen: not( rule!AF_RULE_General_isBlank( ri!xxxxx.createdBy )) ),
Thanks in Advance. Any suggestions appreciated.
Discussion posts and replies are publicly visible
Since you're seeing the error when adding filters, can you also show the value you have on the inputs node of the smart service? Also, depending on your use case you can use the system rule a!exportDSEToExcel() and call it from an interface
What do your filters look like? Is there a chance you're using ri!xxx instead of pv!xxxx ?
Does that expression rule return a list of queryFilter or just a single query filter?
Only other thing I can recommend is looking at the tomcat logs to see if they have more details
It's working when i use a!exporttoDSE, can you have any suggestion on deleting the exported file or all the files in the folder at once? Which is the requirement for my story and i am not saving the doc id in DB
What I have done before is to make sure I always put the file in a temporary folder I make. Then I have a process running nightly or weekly which deletes all documents in the folder.