Hi - From my custom logic, I got below result using a Sub Query. Now I need to pull one object as per this order 1. Zip 2. City 3. State 4. Nation. I want to return the result if the zip matches. If not, then I look for City and same logic till I find a matching object. Note: I morphed my actual n…

Need Help - Break the query execution once it meets any one of its criteria

vvp July 9, 2017, 4:55pm 9

Hi VSR1 - Both Solutions are working…Thank you. May I know which query gives better performance?

Topic		Replies	Views
How can you use array v in v for array end as where clause SQL++	27	1571	March 28, 2021
n1ql help to get documents that meet params SQL++	6	1876	November 13, 2015
How to select an object within a collection? SQL++	30	7590	October 25, 2017
Query Array with variable key SQL++ query , n1ql	21	3587	February 15, 2017
LEFT OUTER JOIN + WHERE clause SQL++ n1ql	51	6342	January 17, 2017