• State Not Answered
  • Replies 13 replies
  • Subscribers 12 subscribers
  • Views 2791 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

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

Balaganapathy Ramamoorthy

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

Parents
  • 0
    Appian Employee

    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

  • 0 in reply to Danny Verb

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

    }

    )

Reply
  • 0 in reply to Danny Verb

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

    }

    )

Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.