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