Difference between revisions of "Issue:Notimageused"
(→Reply) |
|||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 20: | Line 20: | ||
I couldn' t think of anyone who might need something like NOTimageused ... | I couldn' t think of anyone who might need something like NOTimageused ... | ||
| − | Could you send me a working example of a SQL statement (maybe a derivative of the statement produced by DPL when specifying the imageused clause) ? [[User:Gero|Gero]] 15:55, 4 February 2010 (UTC) | + | Could you send me a working example of a SQL statement (maybe a derivative of the statement produced by DPL when specifying the imageused clause) ? |
| + | |||
| + | <dpl> | ||
| + | debug=4 | ||
| + | category=foo | ||
| + | imageused=x.jpg | ||
| + | </dpl> | ||
| + | |||
| + | |||
| + | [[User:Gero|Gero]] 15:55, 4 February 2010 (UTC) | ||
| + | |||
| + | :NOTimageused comes in handy for image maintenance when you use your wiki more like a content management system or when simply all pages in "Category:XY" should use File:XY.jpg. | ||
| + | :"imageused=x.jpg" what did you test there? I mean the opposite. Find out which pages in a category don't use a certain image. | ||
| + | <pre><dpl> | ||
| + | category=Test Images | ||
| + | imageused=Bob Ross.gif | ||
| + | </dpl></pre> | ||
| + | :This returns <nowiki>[[Muha Test]] and [[Muha Test 2]], but I'd like to have the other page in </nowiki>[[:Category:Test Images]]<nowiki> as result: [[User:Subfader/P1]]</nowiki> cos that doesn't use <nowiki>[[File:Bob Ross.gif]]</nowiki> --[[User:Subfader|Subfader]] 21:23, 4 February 2010 (UTC) | ||
| + | |||
| + | == Reply 2 == | ||
| + | |||
| + | I understand perfectly what you want. I asked you to figure out how an appropriate SQL query would have to look like (because I do not have time to figure that out). I gave the query for "imageused" only as a starting point as I thought the inverse query might look similar. | ||
| + | If you come up with a working query I will teach DPL to produce that query. --[[User:Gero|Gero]] 21:32, 4 February 2010 (UTC) | ||
Latest revision as of 22:32, 4 February 2010
| Description: | List pages not using a certain image. |
| Extension / Version: | DPL / ? |
| Type / Status: | Change Request / open |
Problem
Enable the opposite of imageused to find pages which do not use a certain image. Eaxmple:
<dpl> category=Foo notimageused = File:Test.jpg </dpl>
This would return pages in Category:Foo which don't use [[File:Test.jpg]].
Reply
I couldn' t think of anyone who might need something like NOTimageused ...
Could you send me a working example of a SQL statement (maybe a derivative of the statement produced by DPL when specifying the imageused clause) ?
Extension:DynamicPageList (DPL), version 3.2.1: Warning: No results.
Gero 15:55, 4 February 2010 (UTC)
- NOTimageused comes in handy for image maintenance when you use your wiki more like a content management system or when simply all pages in "Category:XY" should use File:XY.jpg.
- "imageused=x.jpg" what did you test there? I mean the opposite. Find out which pages in a category don't use a certain image.
<dpl> category=Test Images imageused=Bob Ross.gif </dpl>
- This returns [[Muha Test]] and [[Muha Test 2]], but I'd like to have the other page in Category:Test Images as result: [[User:Subfader/P1]] cos that doesn't use [[File:Bob Ross.gif]] --Subfader 21:23, 4 February 2010 (UTC)
Reply 2
I understand perfectly what you want. I asked you to figure out how an appropriate SQL query would have to look like (because I do not have time to figure that out). I gave the query for "imageused" only as a starting point as I thought the inverse query might look similar. If you come up with a working query I will teach DPL to produce that query. --Gero 21:32, 4 February 2010 (UTC)
