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

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

This is the filter and i added the complete filter logic down below it is working for other filters even if it large datasets, but ReferralCreatedby filter is throwing that error only for large datasets.

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)
)
)
)

}

)

I am deleting the document after 5 min of  export so i am using 2 smart service so i am not able to execute both in  saveInto function that's y iam not using this a!exportdsetoexcel service

This is the complete filter code, All the filter's are working even for large dataset. But referral createdby filter was not working only for exporting amount of data to excel

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)
)
)
)

}

)

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)
)
)
)

}

)