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
Please add code using Insert->Code
= 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
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?