Skip to main content
B
balaganapathyr0001
March 25, 2021
Question

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

  • March 25, 2021
  • 13 replies
  • 0 views

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.

13 replies

danny.verb
danny.verb
March 25, 2021

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

B
balaganapathyr0001Author
March 25, 2021

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

}

)

Terms & ConditionsAccessibility statement