Am I being dim but how do you simulate a `DISTINCT...
# box-productsr
richard.herbert
05/11/2023, 5:10 PMAm I being dim but how do you simulate a
DISTINCTa
aliaspooryorik
05/11/2023, 5:25 PM
qb.distinct()g
garciadev
05/11/2023, 5:26 PMgarciadev
05/11/2023, 5:26 PMquery.select( "username" ).distinct().from( "users" );a
aliaspooryorik
05/11/2023, 5:26 PM
good find - I couldn't see it in the docs so went to the source code! 🙂
🤘 1
r
richard.herbert
05/11/2023, 5:27 PMThanks both, I couldn't distinct in the docs??? 🤔
Nothing when I searched??
a
aliaspooryorik
05/11/2023, 5:28 PM
I didn't find it either when I searched the docs
r
richard.herbert
05/11/2023, 5:28 PM¯\_(ツ)_/¯
g
garciadev
05/11/2023, 5:28 PMMe neither, but I knew it was related to selecting data, so I just went to that section
👍 1
a
aliaspooryorik
05/11/2023, 5:29 PM
interestingly the 'lens' option in the search returns something
👍 1
aliaspooryorik
05/11/2023, 5:30 PM
r
richard.herbert
05/11/2023, 5:55 PMdistincta
aliaspooryorik
05/11/2023, 5:56 PM
That's how distinct works though. What's the plain SQL you want to produce?
r
richard.herbert
05/11/2023, 5:57 PMThis is the objective...
Copy code
SELECT DISTINCT brand,country,region,area,shopcode,id
FROM shops
ORDER BY brand,country,region,areaa
aliaspooryorik
05/11/2023, 5:57 PM
so that should be:
aliaspooryorik
05/11/2023, 5:59 PM
Copy code
qb.select(
["brand","country","region","area","shopcode","id"
]
).distinct()
.from("shops")
.orderBy(["brand","country
","region","area");aliaspooryorik
05/11/2023, 5:59 PM
i think...
aliaspooryorik
05/11/2023, 5:59 PM
(excuse formatting!)
r
richard.herbert
05/11/2023, 5:59 PMThanks, I'll give that a go. Just doing a quick test with
raw()richard.herbert
05/11/2023, 6:09 PMYep, that's looking good, thanks John 🎉
👍 1
2 Views