-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 26.12.2014 12:02, Dmitri Bogomolov wrote: > 2014-12-13 16:49 GMT+02:00 Brault, Jason <jabra...@bechtel.com > <mailto:jabra...@bechtel.com>>: >> >> Hello,____ >> >> __ __ >> >> We have the Tags plugin implemented with our Trac instance and >> have implemented a tag-based documentation page. Several people >> are creating new wiki articles daily, and some are forgetting to >> add tags. To be able to more easily track these pages down, I was >> wondering if there is any syntax for pulling out wiki pages that >> are not tagged (i.e. NULL). I have tried a few different syntaxes, >> but I have been unable to find out if there is a way. Is there any >> way to accomplish this? Below is one example that I tested, but it >> did not work. Any feedback will be much appreciated.____ >> >> >> [[ListTagged(realm:wiki `NULL`)]]____ >> > Hello! > > You can obtain a list of tables without tags by SQL query: > > SELECT DISTINCT * FROM wiki WHERE name NOT IN (SELECT DISTINCT name > FROM tags WHERE tagspace = 'wiki'); > > This query may be expensive depending on the number of entries in > the tags table.
@Jason: th-users is mainly meant for trac-hacks.org site issues. Use trac-users mailing (trac-us...@googlegroups.com) list instead, please. And you should have mentioned the ticket you created [1] for TagsPlugin in your posting. I'm still missing your feedback on any of the advice given there. Did you try the report yet? Ryan suggested to alternatively create a new Trac wiki macro, but nobody will do that, if it's either exceptionally useful not required. @Dmitri: Top-posting is not nice for reading email threads. Anyway, thanks for the idea of using DISTINCT for the inner query as well. I've edited my earlier suggestion to Jason in the aforementioned ticket accordingly. Steffen Hoffmann [1] http://trac-hacks.org/ticket/12111#comment:3 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iEYEARECAAYFAlSd3cUACgkQ31DJeiZFuHepgwCfWEtD+KA1py6b4EOQeoycUskZ mykAniWzWaP7BzxS+Sqymbj8MFXxbXvh =i5RI -----END PGP SIGNATURE----- _______________________________________________ th-users mailing list th-users@lists.trac-hacks.org https://lists.trac-hacks.org/mailman/listinfo/th-users
