Hi guys,
I my program, I want to be able to say, get me the rows that have 'all'
these tags.
I can do it with group by and having, but Wt doesn't seem to support the
'having' clause, and my SQL foo is not strong enough to do it without (yet).
Here's my postgres query that does what I want:
SELECT tr.*
string_agg(tag.name, ', ' order by tag.name) as tags
FROM transaction tr
LEFT JOIN transaction_tag tt
ON tr.id = tt.transaction_id
JOIN account a
ON tr.account_id = a.id
JOIN tag
ON tag.id = tt.tag_id
group by tr."id", tr."version", tr."date", tr."amount", tr."comments",
tr."account_id", account_name
having array_agg(tag.id) @> ARRAY[36, 48]::BIGINT[]
order by tr.date
limit 10;
Any SQL help appreciated, or ways to get Wt to support a 'having()' func,
similar to 'where()'.
Many Thanks
Matthew Sherborne
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
witty-interest mailing list
witty-interest@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/witty-interest
