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
a!queryLogicalExpression( operator:"AND", filters: { a!queryFilter( field:"primaryBranch", operator:"=", value:ri!settingJson.primaryBranch, applyWhen: not( rule!AF_RULE_General_isBlank(ri!settingJson.primaryBranch) ) ), a!queryFilter( field:"statusDesc", /* Goldfish TCO-23312 Updated the operator to "in" for multi dropdown */ operator:"in", value: a!forEach( items: ri!settingJson.status, expression: trim(fv!item) ), applyWhen: not( rule!AF_RULE_General_isBlank(ri!settingJson.status) ) ), a!queryFilter( field:"statusCategory", operator:"=", value:ri!settingJson.stage, applyWhen: not( rule!AF_RULE_General_isBlank( ri!settingJson.stage ) ) ), a!queryFilter( field:"relationshipOwner", operator:"=", value:ri!settingJson.roName, applyWhen: not( rule!AF_RULE_General_isBlank( ri!settingJson.roName ) ) ), a!queryFilter( field: "teamCode", operator: "in", value: ri!settingJson.teamCode, applyWhen: not( rule!AF_RULE_General_isBlank( ri!settingJson.teamCode ) ) ), a!queryFilter( field:"referralCreatedBy", operator:"=", value:ri!settingJson.createdBy, applyWhen: not( rule!AF_RULE_General_isBlank( ri!settingJson.createdBy )) ), a!queryFilter( field: "createdDate", operator: if( and( not(rule!AF_RULE_General_isBlank(local!fromDate)), rule!AF_RULE_General_isBlank(local!toDate) ), ">=", if( and( rule!AF_RULE_General_isBlank(local!fromDate), not(rule!AF_RULE_General_isBlank(local!toDate)) ), "<=", "between" ) ), value: if( and( not(rule!AF_RULE_General_isBlank(local!fromDate)), rule!AF_RULE_General_isBlank(local!toDate) ), local!fromDateToDateTime, if( and( rule!AF_RULE_General_isBlank(local!fromDate), not(rule!AF_RULE_General_isBlank(local!toDate)) ), local!toDateToDateTime, { local!fromDateToDateTime, local!toDateToDateTime } ) ), applyWhen: or( not( rule!AF_RULE_General_isBlank(ri!settingJson.applicationCreatedDateFrom) ), not( rule!AF_RULE_General_isBlank(ri!settingJson.applicationCreatedDateTo) ) ) ) } )
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.