Menu
▾
▴
Re: [Semediawiki-user] Empty property query - possible?
|
From: trueskew <tru...@gm...> - 2010-08-19 14:51:21
|
Hi Andrew, For your options... I recently had the situation of having articles that could optionally link to an attachment. The user could check the attachment type (PDF, DOC, etc.) or leave the field blank to indicate that it was an article with no attachment. This was done before I new better, and as soon as I wanted a search that consisted of PDFs and non-attachment articles, I got educated. I set a default of ARTICLE for new pages so it would never be blank going forward. For existing pages, I tried to craft a clever method for finding them and filling them in, and then realized it was easier to use Special:Ask to just list my pages in a table, include the sometimes-missing field in Additional printouts, and sort by the field to put the missing entries on the top. I had 30 pages to correct, that wasn't too bad, but if you've got 100's... at least you get the list that way. - skew -----Original Message----- From: Alex M. Hendler [mailto:amh...@on...] Sent: Thursday, August 19, 2010 6:54 AM To: sem...@li...; Laurent Alquier Subject: Re: [Semediawiki-user] Empty property query - possible? ... Alternatively, if you are using forms/templates for this data, you could set a default value for address to be something like "NEEDS ADDRESS", but this might not fully address existing pages. Hope this helps, Alex -- Alex M. Hendler ontolawgy(tm) LLC http://ontolawgy.com ------- Original message ------- From: "Laurent Alquier" <la...@al...> To: sem...@li... Cc: Subject: Re: [Semediawiki-user] Empty property query - possible? Date: Thursday, August 19, 2010 09:42:59 EDT > Unfortunately, it is not possible - mostly for performance reasons. > > In order to do that, the system would have to first retrieve all pages > that match the rest of the query and from these pages, return only > pages that do not have the property requested (which means get the > list of all properties for each page and check that the request > property is not there). > > It is not impossible to do - someone could write an extension that > runs such queries. > > The problem is that is would rapidly become a slow query to perform. > > - Laurent > > On Thu, Aug 19, 2010 at 9:01 AM, <and...@f2...> wrote: > >> Hello. >> >> Unfortunately I got no response to this. Is it really not possible to >> return pages where a particular property is null? Seems like an >> obvious thing to want to do! >> >> Thanks >> Andrew. >> >> >> >> Hi. >> >> Is it possible to run a query that returns pages where a particular >> property is empty? For example, I want to dump all entries where >> where a person has not filled in the address field. >> >> Thanks >> Andrew. >> >> >> >> >> --------------------------------------------------------------------- >> --------- >> This SF.net email is sponsored by >> >> Make an app they can't live without >> Enter the BlackBerry Developer Challenge >> http://p.sf.net/sfu/RIM-dev2dev >> _______________________________________________ >> Semediawiki-user mailing list >> Sem...@li... >> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >> > ---------------------------------------------------------------------------- -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Semediawiki-user mailing list Sem...@li... https://lists.sourceforge.net/lists/listinfo/semediawiki-user |