JP CS Data Query - Ordering and Quantity
Article Index
- JP CS Data Query
- Key Features
- Installation
- Configuration and Usage
- Main Table
- Left Join 1
- Left Join 2
- Ordering and Quantity
- Dynamic Field Mapping
- Join Field Aliases
- Compatibility Fields
- Example - Articles with Categories and Authors
- Example - E-Commerce Products
- JP CS Global Pagination Integration
- Download Key and Updates
- Troubleshooting
- Best Practices
- Summary
- All Pages
Page 8 of 18
Ordering and Quantity
Order By Column
Select a column from the Main Table to determine how returned records should be sorted.
Common examples include:
idcreatedorderingtitle
Order Direction
Select the required sorting direction:
- ASC – Ascending order
- DESC – Descending order
Quantity / Limit
The Quantity / Limit setting controls the maximum number of database records retrieved by the DataQuery source.
The default value is 10.
Start / Offset
The Start / Offset setting determines how many matching records should be skipped before returning results.
The default offset is 0.
For example, an offset of 10 skips the first ten matching records before returning the configured quantity.
