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

Reply
  • 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

Children
No Data