Cargo Queries
From Salish Sea Wiki
Technical Pages
- Categorization System
- Category Update and Page Editing Forms
- Changing Categories
- Development Backlog
- Development Log
- Development Roadmap
- Iconography
- Integrating SER Standards into Wiki Structures
- New User Experience
- Page Editing Forms
- Page Preview Troubleshooting
- Page Templates
- Platform Architecture
- Platform Technical Specifications
- Potential Categories
- Product Page Processing Methods
- Product Page Processing Methods/File Pages
- Product Page Processing Methods/Main Pages
- Product Page Processing Methods/No Year
- 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
}}