User:Bureaucrat 37/sandbox: Difference between revisions

From Foodclubipedia
Jump to navigation Jump to search
(grouping attendees under a single club entry)
(Moving stuff from here to individual sandbox pages)
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
}}

Revision as of 21:09, September 25, 2022

Some testing/experimental/POC links:

Retrieved from "https://foodclub.us/Wikis/Foodclubipedia/0001/index.php?title=User:Bureaucrat_37/sandbox&oldid=339"