User:Bureaucrat 37/sandbox - Revision history

Bureaucrat 37: syndication experiment

2023-06-21T03:31:29Z

syndication experiment

← Older revision		Revision as of 23:31, June 20, 2023
Line 2:		Line 2:

	* [[User:Bureaucrat 37/sandbox/List of Clubs]]: Various things trying to figure out how to best deal with Extension:External Data, using lists of clubs		* [[User:Bureaucrat 37/sandbox/List of Clubs]]: Various things trying to figure out how to best deal with Extension:External Data, using lists of clubs
			* [[User:Bureaucrat 37/sandbox/Feed/Rss]]: Experiment to try out Cargo's new syndication capabilities

Bureaucrat 37: Moving stuff from here to individual sandbox pages

2022-09-26T01:09:35Z

Moving stuff from here to individual sandbox pages

← Older revision		Revision as of 21:09, September 25, 2022
Line 1:		Line 1:
	~~__FORCETOC__~~		Some testing/experimental/POC links:

	~~==list of clubs (dynamic table)==~~		* [[User:Bureaucrat 37/sandbox/List of Clubs]]: Various things trying to figure out how to best deal with Extension:External Data, using lists of clubs
	~~{{#get_db_data:db=fc~~
	~~\| query=list_of_clubs~~
	~~\| data=date=fcc_date,~~
	~~price=fcc_price,~~
	~~restaurant=fcr_name,~~
	~~town=fct_name~~
	}}

	~~{{#format_external_table~~:~~format=dynamic table~~
	~~\|data=Date=date,~~
	~~Price=price,~~
	~~Restaurant=restaurant,~~
	~~Town=town~~
	~~\|rows per page=~~37
	}}

	~~==list~~ of ~~clubs with attendees (table; merge similar cells)==~~
	~~{{#get_db_data:db=fc~~
	~~\| query=test_loc_with_att~~
	~~\| data=date=fcc_date,~~
	~~price=fcc_price,~~
	~~restaurant=fcr_name,~~
	~~town=fct_name,~~
	~~first=fcp_first_name,~~
	~~last=fcp_last_name~~
	}}

	~~{{#format_external_table~~:~~format=table~~
	~~\|data=Date=date,~~
	~~Price=price,~~
	~~Restaurant=restaurant,~~
	~~Town=town,~~
	~~First=first,~~
	~~Last=last~~
	~~\|merge similar cells=yes~~
	}}

	~~==list of clubs~~ with ~~attendees (table; merged name)==~~
	~~{{#get_db_data~~:~~db=fc~~
	~~\| query=test_loc_with_att_name~~
	~~\| data=date=fcc_date,~~
	~~price=fcc_price,~~
	~~restaurant=fcr_name~~,
	~~town=fct_name,~~
	~~attendee=person_name~~
	}}

	~~{{#format_external_table:format=table~~
	~~\|data=Date=date,~~
	~~Price=price,~~
	~~Restaurant=restaurant,~~
	~~Town=town,~~
	~~Attendee=attendee~~
	}}

	~~==list~~ of clubs ~~with attendees (table; grouped)==~~
	~~{{#get_db_data:db=fc~~
	~~\| query=test_loc_with_att_grouped~~
	~~\| data=date=fcc_date,~~
	~~price=fcc_price,~~
	~~restaurant=fcr_name,~~
	~~town=fct_name,~~
	~~attendees=attendees~~
	}}

	~~{{#format_external_table:format=table~~
	~~\|data=Date=date,~~
	~~Price=price,~~
	~~Restaurant=restaurant,~~
	~~Town=town,~~
	~~Attendees=attendees~~
	}}

Bureaucrat 37: grouping attendees under a single club entry

2022-08-08T08:30:13Z

grouping attendees under a single club entry

@@ Line 55: / Line 55: @@
          Town=town,
          Attendee=attendee
 }}

Bureaucrat 37: merging attendee first/last name fields into a single name field

2022-08-08T08:10:35Z

merging attendee first/last name fields into a single name field

@@ Line 37: / Line 37: @@
          Last=last
    |merge similar cells=yes
 }}

Bureaucrat 37: /* list of clubs with attendees (table) */ explicitify

2022-08-08T07:02:09Z

list of clubs with attendees (table): explicitify

← Older revision		Revision as of 03:02, August 8, 2022
Line 18:		Line 18:
	}}		}}

	==list of clubs with attendees (table)==		==list of clubs with attendees (table; merge similar cells)==
	{{#get_db_data:db=fc		{{#get_db_data:db=fc
	\| query=test_loc_with_att		\| query=test_loc_with_att

Bureaucrat 37: explicitifying section names

2022-08-08T07:01:22Z

explicitifying section names

← Older revision		Revision as of 03:01, August 8, 2022
Line 1:		Line 1:
	__FORCETOC__		__FORCETOC__

	==list of clubs==		==list of clubs (dynamic table)==
	{{#get_db_data:db=fc		{{#get_db_data:db=fc
	\| query=list_of_clubs		\| query=list_of_clubs
Line 18:		Line 18:
	}}		}}

	==list of clubs with attendees==		==list of clubs with attendees (table)==
	{{#get_db_data:db=fc		{{#get_db_data:db=fc
	\| query=test_loc_with_att		\| query=test_loc_with_att

Bureaucrat 37: Trying "merge similar cells"... Verdict: Ehhhhhhhh. Not great. Apparently not flexible enough to say "merge on these cells, not those cells.

2022-08-08T07:00:29Z

Trying "merge similar cells"... Verdict: Ehhhhhhhh. Not great. Apparently not flexible enough to say "merge on *these* cells, not *those* cells.

← Older revision		Revision as of 03:00, August 8, 2022
Line 36:		Line 36:
	First=first,		First=first,
	Last=last		Last=last
			\|merge similar cells=yes
	}}		}}

Bureaucrat 37: changing test_loc_with_att to use #format_external_table

2022-08-08T06:56:20Z

changing test_loc_with_att to use #format_external_table

← Older revision		Revision as of 02:56, August 8, 2022
Line 29:		Line 29:
	}}		}}

	~~{\| class="wikitable"~~		{{#format_external_table:format=table
	~~! Date~~		\|data=Date=date,
	~~! Price~~		Price=price,
	~~! Restaurant~~		Restaurant=restaurant,
	~~! Town~~		Town=town,
	~~! First~~		First=first,
	~~! Last~~ {{#~~for_external_table~~:~~<nowiki/>~~		Last=last
	~~{{!}}-~~
	~~{{!}} {{{~~date~~}}}~~
	~~{{!}} {{{~~price~~}}}~~
	~~{{!}} {{{~~restaurant~~}}}~~
	~~{{!}} {{{~~town~~}}}~~
	~~{{!}} {{{~~first~~}}}~~
	~~{{!}} {{{~~last~~}}}~~
	}}		}}
	\|}

Bureaucrat 37: fixing header of test_loc_with_att... hopefully

2022-08-08T06:50:18Z

fixing header of test_loc_with_att... hopefully

← Older revision		Revision as of 02:50, August 8, 2022
Line 30:		Line 30:

	{\| class="wikitable"		{\| class="wikitable"
	! ~~Name~~ {{#for_external_table:<nowiki/>		! Date
			! Price
			! Restaurant
			! Town
			! First
			! Last {{#for_external_table:<nowiki/>
	{{!}}-		{{!}}-
	{{!}} {{{date}}}		{{!}} {{{date}}}

Bureaucrat 37: whoops - accidentally was showing a whole bunch of stuff glommed together as, purportedly, "name"

2022-08-08T06:44:34Z

whoops - accidentally was showing a whole bunch of stuff glommed together as, purportedly, "name"

← Older revision		Revision as of 02:44, August 8, 2022
Line 21:		Line 21:
	{{#get_db_data:db=fc		{{#get_db_data:db=fc
	\| query=test_loc_with_att		\| query=test_loc_with_att
	\| data~~=name~~=date=fcc_date,		\| data=date=fcc_date,
	price=fcc_price,		price=fcc_price,
	restaurant=fcr_name,		restaurant=fcr_name,