Skip to main content
May 14, 2025
Solved

Export Data Store Entity to Excel error

  • May 14, 2025
  • 7 replies
  • 0 views

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

Best answer by harshas2775

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?

7 replies

harshas2775
May 14, 2025

Please add code using Insert->Code

 

May 14, 2025

= 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

harshas2775
May 15, 2025

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?

May 15, 2025

Hi [mention:b467a1e0869c4bcc9fc85475af543f79:e9ed411860ed4f2ba0265705b8793d05] ,

AFAIK this is where the error occured : filters: [{null AND (ihubid > TypedValue[it=1,v=5167])}]

Did u tried adding this for the first logicalExpression in your code?

ignoreFiltersWithEmptyValues: true()

May 15, 2025

yes

May 15, 2025

Did you tried the same query in expression?

If yes, are you getting the data?