Skip to content
This repository has been archived by the owner on Mar 31, 2021. It is now read-only.

Query by view / column creates a query by form / field #24

Open
elem089 opened this issue Apr 5, 2019 · 1 comment
Open

Query by view / column creates a query by form / field #24

elem089 opened this issue Apr 5, 2019 · 1 comment
Assignees
Labels
bug Something isn't working

Comments

@elem089
Copy link

elem089 commented Apr 5, 2019

Building a query by view and column name, then activating Developer Options: the resulting query has the wrong format.
Example:
configured node-demo.nsf (demo db from appdevpack) in dql Explorer, also made sure the db design is indexed in GQFDsgn.cat.
Using query builder I select "Views" >> "AllContactsByState" >> "State" >> "in" >> "CA" and "FL".
The resulting query should be "'AllContactsByState'.State in ('CA', 'FL')".
However it is listed as "State in ('CA', 'FL').
Running "Explain" from the Developer Options has the following result:

Query Processed:
[State in ('CA','FL')]

0. IN    (childct 2) (totals when complete:) Prep 0.0 msecs, Exec 8.401 msecs, ScannedDocs 986, Entries 0, FoundDocs 70
1.State = 'CA' NSF document search estimated cost = 100  
Prep 1.102 msecs, Exec 8.395 msecs, ScannedDocs 986, Entries 0, FoundDocs 50
1.State = 'FL' NSF document search estimated cost = 100  
Prep 0.691 msecs, Exec 0.0 msecs, ScannedDocs 936, Entries 0, FoundDocs 20

Also see screenshot
DQLExplorer_Query_by_view

@dprosper
Copy link
Member

Sorry for the delay in responding...I will look into it.

@dprosper dprosper self-assigned this Apr 24, 2019
@dprosper dprosper added the bug Something isn't working label Apr 24, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants