JoshWeeman
8 years agoQrew Assistant Captain
Cannot locate explanation or syntax for ""Group By"" (gb-) option in query string
Hello, I am attempting to learn how to write more powerful queries within QuickBase. While I am familiar with the "Sort Order" query option (aka "so-" or "sortorder-"), I have only recently seen examples of other query options, such as the "gb-" option as seen below:
opts=so-AA.gb-VX
or
...&options=sortorder-D.gb-X.nos
The latter example came from queries in this QB article below...
https://community.quickbase.com/quickbase/topics/ever-wanted-to-make-your-exact-form-load-conditiona...
The QuickBase API guide makes no mention of the "gb" switch in its 'query options' documentation page here. However I was able to at least deduce from google searches that it facilitiates a "Group By" behavior (I believe). Unfortunately, I have yet to find any explanation about how this switch is used or the proper syntax, etc. I submitted a support request to QB, but got a response back this afternoon explaining that QB simply "adopted existing database query option syntax", and that it is not QuickBase specific, so that's why they have no documentation on it. That would be fine and dandy if I could find any definitive explanation anywhere else online, but I'm not having any luck.
Anyone with query writing experience able to shed some light on how to use the "gb-" switch within query options in QuickBase? Also, what is the ".nos" that is seen in one of the examples above used for? Anyone?
Much thanks in advance!
opts=so-AA.gb-VX
or
...&options=sortorder-D.gb-X.nos
The latter example came from queries in this QB article below...
https://community.quickbase.com/quickbase/topics/ever-wanted-to-make-your-exact-form-load-conditiona...
The QuickBase API guide makes no mention of the "gb" switch in its 'query options' documentation page here. However I was able to at least deduce from google searches that it facilitiates a "Group By" behavior (I believe). Unfortunately, I have yet to find any explanation about how this switch is used or the proper syntax, etc. I submitted a support request to QB, but got a response back this afternoon explaining that QB simply "adopted existing database query option syntax", and that it is not QuickBase specific, so that's why they have no documentation on it. That would be fine and dandy if I could find any definitive explanation anywhere else online, but I'm not having any luck.
Anyone with query writing experience able to shed some light on how to use the "gb-" switch within query options in QuickBase? Also, what is the ".nos" that is seen in one of the examples above used for? Anyone?
Much thanks in advance!