Export Data Store Entity to Excel error

Certified Associate Developer

i'm using Export Data Store Entity to Excel plugin is giving the above error 

= a!queryLogicalExpression(
operator: "AND",
logicalExpressions: {
if(
pv!isAdvanceSearch,
{
a!queryLogicalExpression(
operator: "AND",
filters: {
{
a!queryFilter(
field: "firstname",
operator: "includes",
value: pv!firstName,
applyWhen: a!isNotNullOrEmpty(pv!firstName)
),
a!queryFilter(
field: "middlename",
operator: "includes",
value: pv!middleName,
applyWhen: a!isNotNullOrEmpty(pv!middleName)
),
a!queryFilter(
field: "lastname",
operator: "includes",
value: pv!lastName,
applyWhen: a!isNotNullOrEmpty(pv!lastName)
),
a!queryFilter(
field: "screeningstatus",
operator: "=",
value: pv!scrStatus,
applyWhen: a!isNotNullOrEmpty(pv!scrStatus)
),
a!queryFilter(
field: "country",
operator: "=",
value: pv!country,
applyWhen: a!isNotNullOrEmpty(pv!country)
),
a!queryFilter(
field: "designation",
operator: "=",
value: pv!designation,
applyWhen: a!isNotNullOrEmpty(pv!designation)
),
a!queryFilter(
field: "consultantstatus",
operator: "=",
value: pv!hcpStatus,
applyWhen: a!isNotNullOrEmpty(pv!hcpStatus)
),
a!queryFilter(
field: "fmvstatus",
operator: "=",
value: pv!fmvstatus,
applyWhen: a!isNotNullOrEmpty(pv!fmvstatus)
)
}
}
)
},
{
a!queryLogicalExpression(
operator: "OR",
filters: {
a!queryFilter(
field: "name",
operator: "includes",
value: pv!basicTerms,
applyWhen: a!isNotNullOrEmpty(pv!basicTerms)
),

},
ignoreFiltersWithEmptyValues: true
)
}
)
},
filters: {
a!queryFilter(
field: "consultanttype",
operator: "not in",
value: {
"Patient",
"Caregiver",
"Celebrity Influencer",
"Patient Influencer",
"Patient Life Style Influencer",
"Life Style Influencer",
"Patient Celebrity Influencer"
},
applyWhen: pv!checkRoles = false()
)
}
)

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    Please add code using Insert->Code

     

  • 0
    Certified Associate Developer
    in reply to Harsha Sharma

    = a!queryLogicalExpression(
      operator: "AND",
      logicalExpressions: {
        if(
          pv!isAdvanceSearch,
          {
            a!queryLogicalExpression(
              operator: "AND",
              filters: {
                {
                  a!queryFilter(
                    field: "firstname",
                    operator: "includes",
                    value: pv!firstName,
                    applyWhen: a!isNotNullOrEmpty(pv!firstName)
                  ),
                  a!queryFilter(
                    field: "middlename",
                    operator: "includes",
                    value: pv!middleName,
                    applyWhen: a!isNotNullOrEmpty(pv!middleName)
                  ),
                  a!queryFilter(
                    field: "lastname",
                    operator: "includes",
                    value: pv!lastName,
                    applyWhen: a!isNotNullOrEmpty(pv!lastName)
                  ),
                  a!queryFilter(
                    field: "screeningstatus",
                    operator: "=",
                    value: pv!scrStatus,
                    applyWhen: a!isNotNullOrEmpty(pv!scrStatus)
                  ),
                  a!queryFilter(
                    field: "country",
                    operator: "=",
                    value: pv!country,
                    applyWhen: a!isNotNullOrEmpty(pv!country)
                  ),
                  a!queryFilter(
                    field: "designation",
                    operator: "=",
                    value: pv!designation,
                    applyWhen: a!isNotNullOrEmpty(pv!designation)
                  ),
                  a!queryFilter(
                    field: "consultantstatus",
                    operator: "=",
                    value: pv!hcpStatus,
                    applyWhen: a!isNotNullOrEmpty(pv!hcpStatus)
                  ),
                  a!queryFilter(
                    field: "fmvstatus",
                    operator: "=",
                    value: pv!fmvstatus,
                    applyWhen: a!isNotNullOrEmpty(pv!fmvstatus)
                  )
                }
              }
            )
          },
          {
            a!queryLogicalExpression(
              operator: "OR",
              filters: {
                a!queryFilter(
                  field: "name",
                  operator: "includes",
                  value: pv!basicTerms,
                  applyWhen: a!isNotNullOrEmpty(pv!basicTerms)
                ),
    
              },
              ignoreFiltersWithEmptyValues: true
            )
          }
        )
      },
      filters: {
        a!queryFilter(
          field: "consultanttype",
          operator: "not in",
          value: {
            "Patient",
            "Caregiver",
            "Celebrity Influencer",
            "Patient Influencer",
            "Patient Life Style Influencer",
            "Life Style Influencer",
            "Patient Celebrity Influencer"
          },
          applyWhen: pv!checkRoles = false()
        )
      }
    )

    this is the code there in the filter node input

  • +1
    Certified Lead Developer
    in reply to thammireddybinduniharika

    From the error it looks like one of the filters is null. Also I dont see any filter relating to ihubid >  configured in the above. So start checking filter blocks to find which one is causing issue. 

    Also did you check the tomcat stdout log file to see if more details were there in log about the error?

Reply Children
No Data