Cargo Queries

Technical Pages

• Categorization System
• Category Update and Page Editing Forms
• 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

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
}}