Cargo Queries
From Salish Sea Wiki
Technical Pages
- Cargo-based Template-Form-Table Architecture
- Categorization System
- Category Update (2024)
- Changing Categories
- Development Backlog
- Development Log
- Development Roadmap
- Iconography
- Integrating SER Standards into Wiki Structures
- New Page Type Templates (2024-25)
- New Page Type Templates (2024-25)/Workgroups
- New Templates - Products
- New Templates - Products/File Pages
- New Templates - Products/Main Pages
- New Templates - Products/No Year
- New User Experience
- Page Editing Forms
- Page Preview Troubleshooting
- Page Templates
- Platform Architecture
- Platform Technical Specifications
- Potential Categories
- Promotional Materials
- Terminology
See Introduction Pages
See also Page Editing Forms
This page has information about using structure data created thorugh page edit forms to complete queries
- Template talk:Product - samples of cargo queries
- Cargo Extension - Query Guidance
- Special:ViewData
Syntax
{{#cargo_query:
tables=table1=tableAlias1, table2=tablesAlias2, etc.
|join on=table1.fieldA = table2.fieldB,table2.fieldC=table3.fieldD, etc.
|fields=field1=fieldAlias1,field2=Alias2, etc.
|where=table1.fieldE='some value' AND/OR etc.
|group by=table1.fieldG
|having=table1.fieldG='some value', etc.
|order by=table2.fieldF, etc.
|limit=some number
|offset=some number
|intro=some text
|outro=some text
|default=some text
|more results text=some text
|no html
|max display chars=some number
|format=format
...additional format-based parameters
}}