Difference between revisions of "Issue:Notimageused"

From FollowTheScore
Jump to: navigation, search
(New page: {{Issue |Type = Change Request |Extension = DPL |Version = ? |Description = List pages not using a certain image. |Status = open }} == Problem == Enable the oppos...)
 
 
(7 intermediate revisions by 2 users not shown)
Line 18: Line 18:
  
 
== Reply ==
 
== 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) ?
 +
 +
<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)