• Query By View: built query looks like a Query by Form

    By Lothar Mueller 5 years ago

    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:

    1. 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')]

    1. 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')”