Export DSE to Excel Issue : Error accessing data store entity?

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

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.

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.