[09:43:04] hmm, been a while since I've built a query. I want to retrieve all pages that contain one of three properties [10:01:23] dreamer: do you perhaps mean [[::+]] OR [[::+]] OR [[::+]] [10:01:44] New patchset: Nikerabbit; "Remove Special:QueryCreator" [mediawiki/extensions/SemanticMediaWiki] (master) - https://gerrit.wikimedia.org/r/69073 [10:02:36] Saruman: hmm, I guess. let me try :) [10:03:11] yes, thnx :) [10:03:17] * dreamer needs to get the hang of it again [10:03:56] now also having issue retrieving one property. well actually in the original template it wasn't signified as a property (it's an image in the thing, that is only referred to in the template) [10:04:05] not sure how to explain [10:04:20] wondering how I can add a property (I assume of type page?) to this [10:05:18] so in the template it just says [[File:{{{marqpic}}}|100px]], but how do I turn this in to a property? [10:05:39] just put [[:: .. ]] around it? [10:05:51] (I'd expect that to break this) [10:06:02] New patchset: Foxtrott; "Remove non-existing class from autoloader" [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/69013 [10:08:44] Change merged: jenkins-bot; [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/69013 [10:11:50] indeed it does (break the template) [10:14:16] basically I need a datatype 'file' I guess. which does not exist [10:16:39] I have the feeling that this is going to result in some nasty hack [10:23:14] doh, found it. have to use the special File:: like [[File::File:{{{marqpic}}}|100px]] [10:23:55] at least now the template works again. however I have no clue how to retrieve this in the query .. [10:26:00] ok, also with File::, but this would only work if you have a single property like this in the template [10:26:07] (which I do now, but don't know in the future) [10:35:12] heh, joy. some of the pictures have been uploaded with .JPG instead of .jpg .. and in the query they are not displayed correctly (just the filename and link) [10:37:31] the mimetype of the images is correct though. and they display in other templates just fine. somehow not in this query though [11:08:06] meh, lame bug [11:08:14] * dreamer poked original uploader if he will change the files [11:08:19] not like I can rename them [11:16:15] I see my SMW version is a bit out of date. perhaps this is fixed in newer version? anybodY know? [11:21:04] dreamer: what fix do you refer to? [11:21:22] < dreamer> heh, joy. some of the pictures have been uploaded with .JPG instead of .jpg .. and in the query they are not displayed correctly (just the filename and link) [11:21:28] ^ I wonder if that has been fixed perhaps [11:21:59] I'm not aware of the issue, so I can't say [11:22:28] you can see it here; http://www.dhpforum.nl/wiki/index.php/Marquis#Tabel_met_de_kleurreacties [11:22:47] all items not being displayed have the capitalized extension [11:22:59] their mime-types are correct though. and they are displayed correctly on the corresponding pages [17:37:21] <_bp_> https://semantic-mediawiki.org/wiki/Help:Semantic_templates - this seems to have lost all CSS [17:38:14] If I add a new namespace to my wiki and update $smwgNamespacesWithSemanticLinks do I need to rebuild the SMW tables and/or refresh data in order to be able to query data in that new namespace? [17:43:46] jgay: You'll need to run SMW_refreshData.php [18:04:21] Ftrott, thanks [19:03:36] hmmm, anyone an idea how I can format those File results I get? (still trying to figure out why .JPG doesn't work though) [19:08:39] would've been easier if i could just get the filename and use the template to format it [19:11:38] dreamer: you can, can't you? [19:11:53] I have no idea. it feels like a total hack now [19:11:59] What does? [19:12:20] the way I'm adding a property to these images and retrieving them [19:12:30] (and then the bug why .JPG isn't displaying) [19:12:36] How are you doing that? [19:13:10] I was looking at this: http://www.mediawiki.org/wiki/Extension:Semantic_Forms/Manual/Using_Semantic_Forms_for_file_pages_and_uploads#Template_.2B_form [19:13:15] | [[File::File:{{{File|}}}]] [19:13:37] so I went with that in my page-template: [[File::File:{{{marqpic}}}|100px]] [19:13:47] That won't work, I don't think. [19:14:15] in the table I ask for | ? File (and I have a OR [[File::+]] in the selection) [19:14:42] I get all the results and they get displayed for all the .jpg, not for the .JPG [19:14:44] Oh - does that first call work, to display the image in the page? [19:14:50] yes [19:15:03] Oh, great. [19:15:18] but in my table it's buggy. and I can't add any formatting to the table template [19:15:37] the results get presented as a [[File:]] automatically [19:15:37] So you have different uploaded images, some of type .jpg and some of type .JPG, and only the .jpg files display? [19:15:43] and don't work for .JPG extensions [19:16:00] http://www.dhpforum.nl/wiki/index.php?title=Marquis_reagens&action=edit [19:16:05] eh [19:16:22] anyway, the first table on that page [19:16:57] yaron: the mime-types of those files are exactly the same though [19:17:08] That's weird! [19:17:22] yup [19:17:39] no idea if newer versions of MW and SMW would resolve it. but Saruman didn't recognize it as a known bug [19:18:08] still no clue how I would do the formatting though, since they display as [[File: automatically [19:18:41] would be easier if I could just do | [[File:{{{5}}}|100px]] in the table template [19:18:49] You can. [19:19:00] no, then it breaks [19:19:25] refresh the page :) [19:19:26] By "it", you mean the query table? [19:19:35] yes [19:19:59] Right - you would need to add "{{#set:File={{{5}}} }}" to the template. [19:20:08] That will set the property "silently". [19:20:28] hmm, and build the formatting around that? [19:20:36] ...though I can't see how that would fix the query problem. [19:20:42] Build what formatting? [19:20:57] the [[File:|100px]] or whatever [19:21:11] Yeah, just as you had it above. [19:21:30] hmm, nope [19:21:43] That does seem like an SMW bug - the JPG thing. [19:22:02] You shouldn't need to use a query template, if you just want to display a simple table. [19:22:09] Maybe upgrading would help, who knows. [19:22:14] well if I can just get the filename it should be sorted out [19:22:39] yaron: well I started the template because I wanted to add this 'formatting' to the image there (is how I'm used to) [19:22:48] Ah, I see. [19:22:56] but now I can't display any images [19:23:00] You probably need to add "|link=none" to the query. [19:23:05] using [[File:{{#set:File={{{5}}} }}|100px]] [19:23:22] Er, no. [19:23:48] It would be "[[File:{{{5}}}|100px]] {{#set:File={{{5}}} }}". [19:23:56] ah, hmm. [19:24:29] nope, now I'm back to square one [19:25:14] the #set: doesn't seem to do anything [19:25:39] Well, the property's data is still being set: http://www.dhpforum.nl/wiki/index.php/Property:File [19:26:02] New patchset: Foxtrott; "fix bug: popup form" [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/70465 [19:26:16] well that's on the pages. not in the result query [19:26:34] It's SMW data - if the query isn't displaying it, the problem is in the query. [19:26:38] yaron: but that page makes me think I could use a different name for it as well. 'File' is a bit too generic I guess [19:26:52] ok, well "[[File:{{{5}}}|100px]] {{#set:File={{{5}}} }}" is the problem :P [19:27:12] I doubt it. [19:27:15] since I just get {{{5}}} (with automatic [[File: ]] displaying and no extra file formatting) [19:27:27] That Property:File page still shows the correct data. [19:27:59] the thing is that the results already present themselves as images, not as filenames [19:28:12] Change merged: Foxtrott; [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/70465 [19:28:41] Yeah, you should add "|link=none" to the query. [19:29:01] where in the query then? [19:29:06] Anywhere. [19:29:15] It would be an additional parameter. [19:29:25] but I want other results to be links. or then I put brackets in the template? [19:29:51] Yes. [19:30:55] meh, almost working (had to remove File: from the template) [19:31:33] somehow {{PAGENAME}} gets in the results o.O [19:32:06] it does fix the jpg vs JPG problem though! [19:32:28] and I need an #if: for the entries without this property [19:32:28] Weird. Cool, though. That does seem like an SMW #ask bug. [19:32:47] You might be able to fix that by using {{{5|}}} instead of {{{5}}}. [19:32:55] ok [19:32:59] The #if thing, that is. [19:33:00] I never fully got that [19:33:21] | [[{{{5}}}|100px]] {{#set:File={{{5}}} }} << which one? or both? [19:34:52] hmm, noop [19:35:07] Might as well do both. [19:35:29] <_bp_> hey can someone help me out with using ArrayExtension to deliver some grouped results [19:35:38] yaron: nah, didn't work. fixed it with an #if: [19:36:01] only thing left now is why the hell {{PAGENAME}} is getting in the result o.O [19:36:04] _bp_: ArrayExtension is the old name of that extension; it's now called Arrays. [19:36:09] <_bp_> oooh [19:36:12] Maybe you need to upgrade your software... [19:36:20] <_bp_> no this is 1.8 [19:36:39] Well, that extension, in any case. [19:39:27] <_bp_> anyway i have a bunch of cities with retail inspection letters and I need to show a list of cities, with a count for number of letters issued per city [19:40:21] Ah - yes, Arrays could help with that. [19:41:37] yaron: can I exclude a particular result from the query? (I can't understand why the pagename shows up) [19:44:04] yo [19:44:06] yaron: around? [19:44:16] Hello! Yes. [19:44:20] yaron: Hi! [19:44:35] http://smw.referata.com/wiki/Excluding_a_page_from_an_inline_query << hmm [19:44:39] yaron: I am in need of help. trying to grab an Author property from a page, then use it to reference semantic data on the user page. [19:44:55] dreamer: where is the pagename (or {{{PAGENAME}}}) showing up? [19:44:56] yaron: the Author property references the wiki user page. [19:45:12] Alright. [19:45:24] yaron: in the resulting table [19:45:45] Here? http://www.dhpforum.nl/wiki/index.php/Marquis_reagens I don't see it. [19:46:01] first table. under M [19:47:04] Oh... you mean that "Marquis reagens" shows up in the results. [19:47:12] That might have been phrased a little more clearly. [19:47:19] yes, sorry [19:47:42] I generalized it a bit too much :P [19:47:44] yaron: see http://wiki.zenoss.org/Template:ArticleFooter [19:48:21] yaron: trying to get the author's wiki name, then pass it to a template do grab the bio from the user page. [19:48:33] thus displaying the author's bio at the bottom of the article. [19:48:43] Alright. So, what's the issue? [19:49:08] dreamer: you shouldn't be setting the value in the query template - only in the *display* template. [19:49:40] yaron: the issue is that rather than getting the raw text of the username, I am getting the "Linkified" text... [19:49:53] yaron: oh, the |link=none ? [19:49:54] doh [19:50:11] No, the #set call. [19:50:11] yaron: you can see it malfunction here, at the bottom: http://wiki.zenoss.org/ZenPack_Generator_Interview/Usage_Case [19:50:22] yaron: ok, now I'm completely confused :) [19:50:27] drobbins: speaking of "|link=none", that's what you should use. [19:50:42] dreamer: you should remove the #set from here: http://www.dhpforum.nl/wiki/index.php?title=Template:Marqtab&action=edit [19:50:56] yes, understood [19:51:06] and then, put it after | ? File ? [19:51:12] or anywhere? [19:51:19] Ah... now I get the issue. We were talking about two different templates. [19:51:32] I thought you were asking about the display template, the one being used by all those pages. [19:51:37] (Assuming there is one.) [19:51:40] yes, no [19:51:41] Not the query template. [19:51:44] I meant the table of course [19:51:53] Of course? :) [19:51:56] I had no problems in the display templates on the pages [19:52:03] like I said before: the images show up fine there [19:52:04] Okay, that's nice. [19:52:17] (I'm really bad at all this specialized lingo haha) [19:52:24] Anyway, take out #set. [19:52:53] Ah, you've done that. Although I think you removed too many curly brackets. [19:53:16] yay, it worketh :) [19:53:22] yaron: yeah indeed, I destroyed the if :) [19:53:51] <_bp_> ok back to Arrays... [19:53:53] <_bp_> so far i have this: [19:53:56] _bp_: enjoy :) [19:54:01] <_bp_> lol [19:54:07] yaron: thnx a lot. weird f-ing stuff. but it works now \o/ [19:54:13] <_bp_> i am a design guy who for some reason got pushed into an SMW task [19:54:14] (and I should probably file a bugreport somewhere ..) [19:54:27] <_bp_> i am having a ton of fun by which i mean it is like bathing in lava [19:54:28] <_bp_> {{#arraydefine: foo [19:54:28] <_bp_> | {{#ask:[[Category:City]] |?Letter }} [19:54:28] <_bp_> | , | print=list, sort=asc, unique [19:54:28] <_bp_> }} [19:55:13] <_bp_> cool, that got me this - http://warnings.survos.com/wiki/Test [19:55:48] _bp_: doesn't Arrays offer an #arraycount or #arraysize or something? [19:57:38] <_bp_> arraysize i think [19:57:42] <_bp_> i'm unclear on its use though [19:58:39] <_bp_> syntax i mean [19:59:31] I don't know much about that extension; maybe someone else does. [19:59:41] ...but I would think that's the only real option here. [19:59:56] #arraysize, that is. [20:04:29] _bp_: {{#arraydefine: foo [20:04:29] | {{#ask:[[Category:City]] |?Letter|format=list|link=none|sep=;|limit=500|searchlabel=}} [20:04:30] | ; | print=list, sort=asc, unique [20:04:30] }} [20:05:12] _bp_: Problem is, you get so many results that it exceeds your query limit (currently 500) [20:05:38] <_bp_> oh haha [20:05:43] <_bp_> i guess i should limit it [20:05:49] <_bp_> yeah there are a lot of notices [20:07:02] <_bp_> oh heh yaron i just realized [20:07:07] <_bp_> it's your book in front of me [20:07:09] <_bp_> headdesk [20:14:41] back [20:15:09] yaron: I tried |link=none, will try that again. [20:16:10] yaron: ok, |link=none gets me closer. On refresh, I get the full name. [20:16:24] let me see if I can get the bio. [20:16:24] or a link to the user page. [20:17:09] yaron: ok, if you look, you will see the semantic Author data says "Trelane" (which is the wiki user name). but |link=none returns "Andrew D. Kirch" [20:17:29] so I can't use that to directly link to the user page. [20:17:58] Ideally, I want to get "Trelane", not "Andrew D. Kirch". Then this problem is solved. [20:19:00] |linke=none turns "Andrew D. Kirch" (hyperlinked) to "Andrew D. Kirch" (non-hyperlinked) which is not exactly what I want. [20:47:38] I'm having a strange problem, hoping someone can help. I have a about 70 pages for people in my company (not in the USER namespace) and is in Category:Person. Each page has a "Reports To" property set to their manager. [20:48:02] When I use this inline query, I get all the proper results: [20:48:05] {{#ask: [[Category:Person]] [[Reports to::+]] |mainlabel=Name |?Reports to }} [20:48:25] When I use this inline query, I only get ONE result: [20:48:26] {{#ask: [[Category:Person]] [[Reports to::+]] |mainlabel=Name |?Reports to }} [20:48:47] Ooops.. THIS query only gets one result: [20:48:48] {{#ask: [[Reports to::+]] |mainlabel=Name |?Reports to }} [20:52:34] The default data store is is a Sparql database (4store) [20:52:56] $smwgDefaultStore = 'SMWSparqlStore'; $smwgSparqlDatabase = 'SMWSparqlDatabase4Store'; [20:54:59] Any ideas why I'm getting two different results? [20:57:13] The second inline query should return the same results as the first (if not MORE results, IE pages that contain the property but not in the Category:Person) [21:17:35] drobbins: hello, are you still there? [21:17:44] ...and do you still have the problem? [21:18:14] _bp_: LOL [21:25:24] New patchset: Foxtrott; "fix bug: Added wikitext in the system message Mediawiki:Minoredit is not parsed when using "edit with form"" [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/70544 [21:26:38] New patchset: Foxtrott; "fix bug: Added wikitext in the system message Mediawiki:Minoredit is not parsed when using "edit with form"" [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/70544 [21:27:28] Change merged: Foxtrott; [mediawiki/extensions/SemanticForms] (master) - https://gerrit.wikimedia.org/r/70544 [21:29:24] Yep, I'm still here (and still have the problem) [22:45:28] back