Building a filter with a lot of components

Lisa Stewart
Contributor
December 21, 2022

Below is what I am trying to write, and it is not working. I can't figure out where I am going wrong. Help please.

 

project = XXXXX AND status = ("Open", "In Progress") AND component = (Billing, Claims, Enrollment, "Stars & HEDIS", Quality, "Reporting and Analytics", Risk, "OPTUM- CES", "OPTUM- HSS")

1 answer

1 accepted

0 votes
Answer accepted
Sushant Verma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 21, 2022

Hi @Lisa Stewart 

Just try : 

project = XXXXX AND status in ("Open", "In Progress") AND component in ("Billing", "Claims", "Enrollment", "Stars & HEDIS", "Quality", "Reporting and Analytics", "Risk", "OPTUM- CES", "OPTUM- HSS")

Regards,
Sushant Verma

Lisa Stewart
Contributor
December 21, 2022

Wow, that one little word "in" made all the difference. Thank you so much Sushant!

 

Thanks,

Lisa

Sushant Verma
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 21, 2022

@Lisa Stewart You're welcome. If this was helpful can you please mark as accepted to help others.

Regards,
Sushant Verma

Suggest an answer

Log in or Sign up to answer