[05:50:37] May I have my account back? I did nothing wrong and I would like to return. [05:51:02] Please revi unlock my account [05:51:07] I did nothing wrong [05:51:34] Pleaaaaaaaaaaaase [05:51:46] I want my account back I want my account back [05:52:22] I want my account back I want my account back I want my account back I want my account back I did nothing wrong I did nothing wrong I got locked for no reason all because of revi I want my account unlocked now [05:52:45] Please Vermont and revi apologize to me now for treating me like garbage [05:53:33] Cam11598 will you liberate me from revi and Vermont and unlock my account! [05:53:57] please I’m begging someone to unlock my account cam11598 [05:54:01] pleaaaaaaaaaase [05:54:06] pleaaaaaaaaase [05:54:12] Sorry I lack the technical ability to do so. [05:54:24] LaurenCox600: Never gonna happen. [13:01:18] I have two questions about the WD Query Service visualizations [13:04:01] Lucas_WMDE you might know something about this :) [13:04:26] maybe? I can’t read minds :P [13:04:33] ask the questions and then I’ll see if I can answer them [13:04:35] :) [13:05:14] in the map view, how to control the order of display in the popups? [13:05:38] I think it’s more or less the order of variables in the SELECT? [13:05:45] at least I’m not aware of any other way to control it [13:06:45] yes but it isn't exactly that. Let me see if I can get a link [13:08:59] I'm having some trouble with the URL shortener, so here's the full link: [13:11:19] https://query.wikidata.org/#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fcoord%22%2C%22%3Frgb%22%5D%7D%0A%23koulu2english%0ASELECT%0A%3Fitem%20%3FitemLabel%0A%28SAMPLE%28%3Fkuva%29%20AS%20%3Fkuva%29%0A%28SAMPLE%28%3Fperustettu%29%20AS%20%3Fperustettu%29%0A%28SAMPLE%28%3Flakkautettu%29%20AS%20%3Flakkautettu%29%0A%28CONCAT%28%3Ftoimiala%2C%20%20GROUP_CONCAT%28DISTINCT%20%3FindustryLabel%3BSEPARATOR%3D%27%2C%20%27%29%29%20AS%20%3Findustr [13:11:19] ies%29%0A%28CONCAT%28%3Fesiintyma%2C%20GROUP_CONCAT%28DISTINCT%20%3FinstanceLabel%3BSEPARATOR%3D%27%2C%20%27%29%29%20AS%20%3Finstances%29%0A%28CONCAT%28%3Fperustaja%2C%20GROUP_CONCAT%28DISTINCT%20%3FfounderLabel%3BSEPARATOR%3D%27%2C%20%27%29%29%20AS%20%3Ffounders%29%0A%28CONCAT%28%22%E2%80%A2%20Highest%20number%20of%20employees%3A%20%22%2CSTR%28%3FmaxEmployees%29%2C%22%20%28in%20%22%2C%20%3FpointInTimeStr%2C%22%29%22%29%20AS%20%3Ftyon [13:11:20] tekijoita%29%0A%3Fcoord%20%3Frgb%20%23these%20are%20hidden%0AWHERE%0A%7B%0A%23SUBQUERYSTART%0A%20%20%20%20%7B%0A%20%20%20%20SELECT%20%3Fitem%20%28MAX%28%3Femployees%29%20AS%20%3FmaxEmployees%29%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP5008%20wd%3AQ76297381%20.%0A%20%20%20%20OPTIONAL%20%0A%20%20%20%20%20%20%7B%0A%20%20%20%20%3Fitem%20p%3AP1128%20%3Fstatement.%0A%20%20%20%20%3Fstatement%20ps%3AP1128%20%3Femployees.%0A%20%20%20%20%20 [13:11:25] %20%7D%0A%20%20%20%20%7D%0A%20%20%20%20GROUP%20BY%20%3Fitem%20%3FitemLabel%0A%20%20%20%20%7D%0A%23SUBQUERYEND%0A%20%20%0A%20%20%3Fitem%20wdt%3AP5008%20wd%3AQ76297381%20.%20%23koordinaatit%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP625%20%3Fkohdecoord.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20p%3AP159%20%5B%20ps%3AP159%20%3Fkont%3B%20pq%3AP625%20%3Fkonttoritruecoord%20%5D.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP669%20%5B%20wdt%3AP625%20%3Fkat [13:11:33] ucoord%20%5D.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP131%20%5B%20wdt%3AP625%20%3Faluecoord%20%5D.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP159%20%5B%20wdt%3AP625%20%3Fkonttoricoord%20%5D.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP276%20%5B%20wdt%3AP625%20%3Fsijainticoord%20%5D.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP740%20%5B%20wdt%3AP625%20%3Fperustamiscoord%20%5D.%7D%0A%20%20BIND%28COALESCE%28%3Fkohdecoord%2C%20%3Fkonttoritru [13:11:37] ecoord%2C%20%3Fkatucoord%2C%20%3Faluecoord%2C%20%3Fkonttoricoord%2C%20%3Fsijainticoord%2C%20%3Fperustamiscoord%29%20AS%20%3Fcoord%29.%0A%20%20%0A%20%20%20BIND%28COALESCE%28%3Fkoordinaatit%2C%20%3Fhqcoord%29%20AS%20%3Fcoord%29.%0A%20%20%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP18%20%3Fimg.%7D%20%23kuvat%0A%20%20wd%3AQ76297381%20wdt%3AP2910%20%3Ftehdaskuva%0A%20%20BIND%28IF%28BOUND%28%3Fimg%29%2C%20%3Fimg%2C%20%3Ftehdaskuva%29%20AS%20%3Fk [13:11:42] uva%29%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP31%20%3Finstance.%7D%20%23tiedot%0A%20%20BIND%28IF%28BOUND%28%3Finstance%29%2C%22%E2%80%A2%20Type%3A%20%22%2C%22%20%22%29%20AS%20%3Fesiintyma%29%0A%20%20%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP112%20%3Ffounder.%7D%0A%20%20BIND%28IF%28BOUND%28%3Ffounder%29%2C%22%E2%80%A2%20Founded%20by%3A%20%22%2C%22%20%22%29%20AS%20%3Fperustaja%29%0A%20 [13:11:47] %20OPTIONAL%20%7B%3Fitem%20wdt%3AP571%20%3Ffounded.%7D%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP576%20%3Fdissolved.%7D%0A%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fitem%20p%3AP1128%20%3Fstatement.%0A%20%20%20%20%20%20%3Fstatement%20ps%3AP1128%20%3FmaxEmployees.%0A%20%20%20%20%20%20%3Fstatement%20pq%3AP585%20%3FpointInTime.%0A%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%0A%20%20BIND%28STR%28YEAR%28%3FpointInTime%29%29AS%3FpointIn [13:11:52] TimeStr%29.%0A%20%20%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP452%20%3Findustry.%7D%0A%20%20BIND%28IF%28BOUND%28%3Findustry%29%2C%22%E2%80%A2%20Industry%3A%20%22%2C%22%20%22%29%20AS%20%3Ftoimiala%29%0A%20%20%20%20%0A%20%20BIND%28STR%28YEAR%28%3Ffounded%29%29AS%3FfoundedStr%29.%0A%20%20BIND%28STR%28YEAR%28%3Fdissolved%29%29AS%3FdissolvedStr%29.%0A%20%20BIND%28CONCAT%28%22%E2%80%A2%20Founded%20in%3A%20%22%2C%20%3FfoundedStr%29%20AS%20%3Fp [13:11:58] erustettu%29.%0A%20%20BIND%28CONCAT%28%22%E2%80%A2%20Dissolved%20in%3A%20%22%2C%20%3FdissolvedStr%29%20AS%20%3Flakkautettu%29.%0A%20%20%0A%20%20BIND%28%2236454f%22%20AS%20%3Frgb%29%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cfi%22.%0A%20%20%20%20%3Finstance%20rdfs%3Alabel%20%3FinstanceLabel%20.%0A%20%20%20%20%3Findustry%20rdfs%3Alabel%20%3FindustryLabel%20.%0A%20%20%20%20%3Ffounder%2 [13:12:04] 0rdfs%3Alabel%20%3FfounderLabel%20.%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel%20.%0A%20%20%7D%0A%7D%0AGROUP%20BY%20%3Fperustaja%20%3Ftoimiala%20%3Fcoord%20%3Frgb%20%3FmaxEmployees%20%3FpointInTime%20%3FpointInTimeStr%20%3Fesiintyma%20%3Fitem%20%3FitemLabel%0AORDER%20BY%20ASC%20%28%3FitemLabel%29 [13:12:11] uhhhhhh [13:12:19] that got broken across like half a dozen messages on my end [13:12:45] ok but it looks like I can still copy it [13:12:55] yeah, it's a long query, sorry, and I'm probably not doing things in the most optimal way [13:15:33] ?tyontekijoita "Highest number of employees" comes on top, no matter what I do. [13:16:51] hm [13:16:57] I tweaked the query to make the number of employees non-optional [13:17:08] to make it easier to find such points on the map [13:17:15] and now it’s no longer on top o_O [13:17:29] (comment out L19, if you want to reproduce it) [13:17:33] okay that sounds weird [13:18:02] * Lucas_WMDE peeks at the code [13:20:40] yeah, as far as I can tell they should be in inverse SELECT order [13:21:32] https://gerrit.wikimedia.org/g/wikidata/query/gui/+/c6955ea7fb7da155fe101cd47c22f5906793801f/wikibase/queryService/ui/resultBrowser/helper/FormatterHelper.js#92 [13:21:51] it iterates over the fields of the row and prepends each to the rest of the popup [13:23:10] and I don’t think anything is supposed to reorder the rows [13:24:02] it works more or less that way until I use the OPTIONAL in employees again [13:28:50] I'm thinking it's because I use different aggregate functions. Some are GROUP_CONCAT and CONCAT, others CONCAT and yet others SAMPLE [13:35:06] If you don't know the answer to this problem right now, maybe I can ask the second question [13:37:33] ProTip: Long queries: use https://w.wiki [13:37:54] https://meta.wikimedia.org/wiki/Special:UrlShortener [13:39:04] yes revi, but "The URL is too long, the maximum size is 2,000 characters". [13:39:14] lol [13:39:17] that is.... too bad. [13:39:27] even too long ha [13:39:56] it's not optimized for brevity. It's optimized for other things :) [13:40:07] ideally WDQS interface should generate its own shortlink [13:40:35] yes, I got an error there as well. I had a hunch it's because the URL is too long. [13:41:01] That's because it just utilizes w.wiki [13:41:11] which means it's same interface as Special:UrlShortener [13:41:34] yes that makes sense [13:48:51] Lucas_WMDE I also wanted to ask about edgeLabels in the graph view [14:38:09] I don’t really remember how those work tbh [14:38:15] I rarely use them myself [14:38:30] (see https://phabricator.wikimedia.org/T220703 for the URL shortener issue btw) [14:38:37] this might be just an optimization problem at heart [14:39:10] the problem is that sometimes most of the edgeLabels are simply dropped out. [14:40:13] If there is no maximum limit to them, I suspect my query fetches the edgeLabels ( wikibase:directClaim ) too soon or too late [14:42:03] this works: https://w.wiki/mps [14:42:23] but on line 7 change the year to 1862 [14:46:09] hm, no idea why that version loses most of the edge labels [14:46:34] I thought maybe some connections exist more than once, but for the one person I checked in the Table view, that doesn’t seem to be the case [14:47:20] yeah. I've also tried it with the edgeLabels in SAMPLE or GROUP_CONCAT and the result is the same [14:48:59] but to your knowledge, there is no limit on the number of edgeLabels? [14:49:04] no [14:50:22] I wish I knew where to start troubleshooting this [14:56:18] when I click on "Hierarchical layer right to left" they appear on the same query... [14:57:30] and stay there when I click on "Non-hierarchical layout" [14:58:12] so maybe it's not about the query but the renderer. If some of the arrows are initially too short, too curved or close to one another, maybe that causes problems [19:54:32] Finnusertop_at_w: Maybe not use Finnish words for the variables: ?tyontekijoita -> ?ty [20:00:08] sure will make troubleshooting easier for others, but shouldn't affect the actual output right? [20:02:01] but also, when things should be working in theory, but they don't with my query, I want to provide the actual query [20:03:17] anyway, I got the map figured out. I'm still struggling with the missing edgeLabels.