Sandbox
m (→Today query) |
m (→Today query) |
||
| Line 48: | Line 48: | ||
| searchlabel= | | searchlabel= | ||
| sort=StartDate | | sort=StartDate | ||
| − | | limit= | + | | limit=3 |
| format=list | | format=list | ||
}} | }} | ||
| − | And with Currenttime instead of 00:00: | + | And with Currenttime instead of 00:00: (which isn't really what the TODAY query is about. |
{{#ask:[[Category:Event||ExternalEvent||Workshop||Meeting]] | {{#ask:[[Category:Event||ExternalEvent||Workshop||Meeting]] | ||
[[Is Recurring::no]] | [[Is Recurring::no]] | ||
| Line 59: | Line 59: | ||
| ?StartDate= | | ?StartDate= | ||
| intro='''TODAY''':_ | | intro='''TODAY''':_ | ||
| + | | searchlabel= | ||
| + | | sort=StartDate | ||
| + | | limit=1 | ||
| + | | format=list | ||
| + | }} | ||
| + | |||
| + | As well as a NOW query: | ||
| + | {{#ask:[[Category:Event||ExternalEvent||Workshop||Meeting]] | ||
| + | [[Is Recurring::no]] | ||
| + | [[StartDate::<{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} {{CURRENTTIME}} ]] | ||
| + | [[EndDate::<{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} {{CURRENTTIME}} ]] | ||
| + | | ?StartDate= | ||
| + | | intro='''NOW''':_ | ||
| searchlabel= | | searchlabel= | ||
| sort=StartDate | | sort=StartDate | ||
Revision as of 16:45, 8 November 2009
Contents |
Poll
<poll> Do you like this extension? Yes No I don't know yet. </poll>
Today query
Now is 21:01
A date that has a time is > than one that does not. :(
This should be a workable workaround
Debug Output by SMWSQLStore3
Generated Wiki-Query
[[Category:Event||ExternalEvent||Workshop||Meeting]] [[Is Recurring::no]] [[StartDate::≥23 November 2024 00:00:00]] [[StartDate::≤23 November 2024 23:59:00]]
Query Metrics
Query-Size:7Query-Depth:1
SQL Query
SELECT DISTINCT t9.smw_title AS t,t9.smw_namespace AS ns FROM `smw_object_ids` AS t9 INNER JOIN `smw_fpt_inst` AS t1 ON t9.smw_id=t1.s_id INNER JOIN `t2` AS t2 ON t1.o_id=t2.id INNER JOIN `smw_di_blob` AS t3 ON t1.s_id=t3.s_id INNER JOIN `smw_di_time` AS t5 ON t1.s_id=t5.s_id INNER JOIN `smw_di_time` AS t7 ON t1.s_id=t7.s_id WHERE (((t3.o_hash='no') AND t3.p_id='86') AND ((t5.o_sortkey>='2460637.5') AND t5.p_id='59') AND ((t7.o_sortkey<='2460638.4993056') AND t7.p_id='59')) ORDER BY t5.o_sortkey ASC LIMIT 2 OFFSET 0;Auxilliary Tables Used
- Temporary table t2
Recursively computed hierarchy for element(s) ('490'),('465'),('1110').
Errors and Warnings
None
{{#ask:[[Category:Event||ExternalEvent||Workshop||Meeting]]
[[Is Recurring::no]]
[[StartDate::>{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} 00:00]]
[[StartDate::<{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} 23:59]]
| ?StartDate=
| intro='''TODAY''':_
| searchlabel=
| sort=StartDate
| limit=1
| format=list
}}
And with Currenttime instead of 00:00: (which isn't really what the TODAY query is about.
As well as a NOW query:
NOW: Arduino Soldering (15 March 2009 15:00:00)
External Data
asking for events from our wiki
{{#get_external_data:https://www.hackerspace.lu/wiki/Special:Ask?title=Special%3AAsk&q=%0D%0AStartDate::+&po=%3FStartDate&sc=0&eq=yes&p=format%3Dcsv&sep=%3D,|CSV with Header|event=|startdate=StartDate}}
{{#for_external_table: * {{{event}}} starts on {{{startdate}}}
}}
asking for external data from hackerspaces.org
{{#get_external_data:http://hackerspaces.org/wiki/Special:Ask?title=Special%3AAsk&q=%0D%0A&po=%3FStart%20date%0D%0A%3Ftitle%0D%0A&sc=0&eq=yes&p=format%3Dcsv&sep=%3D,%7CCSV with Header|event=title|startdate=Start date}}
{{#for_external_table: * {{{event}}} has {{{startdate}}}
}}
asking for opendoors startdate from our wiki {{#get_external_data:https://www.hackerspace.lu/wiki/Special:Ask/-5B-5BOpenDoors-5D-5D/-3FStartDate/-3FEndDate/format%3Dcsv/sep%3D,%7Ccsv with header|sdate=StartDate|edate=EndDate}}
- Opendoors has StartDate {{#external_value:sdate}} and ends on {{#external_value:edate}}
asking for smw sample data from semanticweb.org: {{#get_external_data:http://semanticweb.org/wiki/Special:Ask/-5B-5BGermany-5D-5D/-3FBorders/-3FPopulation/-3FArea/format%3Dcsv/sep%3D,%7Ccsv with header|bordered countries=borders|population=population|area=area}}
- Germany has area {{#external_value:area}}.
OggHandler
FlashMP3
Howto: http://www.mediawiki.org/wiki/Extension:FlashMP3
-
Error: file
02 - Mineralogique.mp3not found
amazon
Note: if you don't see anything, maybe try turning Adblock off :D
Single box:
Single direkt link without preview: Hackers
Single direkt link with preview: Circuit Bending
Single search link: Books for HackersOlder Sandbox stuff on Sandbox/2
