xPages-sessionScope.query returns more than it should

HCL Domino Domino Forum
1

I’m building a query for a ViewControl which looks something like this:

FIELD StatusOfIssue = “PV” AND FIELD Product = “xyz”

We have 2 status: (1) “PV” and (2) “PV Assign”

This query is returning docs with BOTH statuses since the equals sign is really a ‘contains’ operator. Is there a way to build a query so it’s an Exact match?

thanks

clem

2

Subject: Search criteria

How about adding alsoAND NOT FIELD StatusOfIssue = “PV*”

Will this eliminate the additional word variants. If it also eliminates PV, I guess you could also use “PV *”

3

Subject: Thanks

Hey Paul

Thanks. The ’ *’ didn’t work but replacing it with " Assign" did. It’s not the best solution but it does work for now. Appreciate the suggestion!

Clem