• State Not Answered
  • Replies 13 replies
  • Subscribers 12 subscribers
  • Views 2782 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 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)
    )
    )
    )

    }

    )

Reply
  • 0 in reply to Danny Verb

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

    }

    )

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