Hello,
I’m building a wine tastingnote website and I want to get a distinct list of all countries, regions, appellations etc. I was hoping that pdoResources would be able to do it, but I can’t get it to work and I have a really hard time to find any examples or proper documentation… I think it is possible to use &groupBy as it is being presented as a generic pdoTools option, but I do not know how to refer to the column I want it grouped by… So to be clear I want to have a “select distinct” on e.g. the winecountry column.
Here’s an example: give me a list of all countries used in my tasting notes:
[[pdoResources?
&parents=34
&depth=0
&tpl=@INLINE <li>[[+tv.tn-winecountry]]</li>
&includeTVs=tn-winecountry
&limit=100
&groupBy=tn-winecountry
&showLog=1
&sortby={“tn-winecountry”:“ASC”}
]]
What am I doing wrong?
Thanks so much --Mike
PS pdoResources seems to work just fine with close to 9000 tasting notes. Simplesearch is a bit slower but still not too bad. When everything’s set up correctly I’ll report back on behavior of a lot of resources, as I have the impression that that information is missing a bit --M.