Set up node-demo.nsf from the AppDevPack on my Server and registered it in GQFDsgn.cat.
Built a query “by view” using the “AllContactsByState” view
Query Buidler offers me all columns of that view. I select “State”
Operator is “in”
I enter “CA” and “FL”
Results should show FirstName, LastName and EMail fields
Query runs well, result appears to be complete.
But the resulting Query appears to be wrong as it does not use the view.
“Developer Options » Domino Console"says
load domquery -f node-demo.nsf -q “State in ('CA','FL')”
Explain tells me this, which looks like a query by form:
- IN 1.State = 'CA' NSF document search estimated cost = 100
1.State = 'FL' NSF document search estimated cost = 100
Query Processed:
[State in ('CA','FL')]
- IN (childct 2) (totals when complete:) Prep 0.0 msecs, Exec 39.322 msecs, ScannedDocs 986, Entries 0, FoundDocs 70
1.State = 'CA' NSF document search estimated cost = 100
Prep 2.646 msecs, Exec 39.316 msecs, ScannedDocs 986, Entries 0, FoundDocs 50
1.State = 'FL' NSF document search estimated cost = 100
Prep 2.146 msecs, Exec 0.0 msecs, ScannedDocs 936, Entries 0, FoundDocs 20
IMHO the query should be, which using a 'real' DomQuery has much better explain results:
load domquery -f node-demo.nsf -q “'AllContactsByState'.State in ('CA','FL')”