How to Use Tables
There are many different types of tables within ColdTrack Live, it is one of the primary ways in which we display data for users to reference. Even though the types of tables are different, the primary functionality is the same between them. You can view all of the instances we have for a specific data type at a glance, or open a record for detailed information on a specific instance. You can filter the data, adjust the columns, or sort by field to make the table display the exact information you want.
- For Example: If I am looking for line items on a specific order, I can navigate to the order table, add a filter for the Id, and open the Order Record. I can scroll down to "Line Items" to see the Line Items associated with that order.
Common Table Types
Some of the most common Table types include:
Order Table: Shows all your customer orders
Item Table: Shows all items (regardless of inventory amount)
Item Inventory Table: Shows inventory of all your items
Parcel Table: Shows individual parcels within an order
Kit Table: Shows all of the kits associated with your items
Item Substitution Plan: Shows all Item Substitution Plans set up for your items
Table Locations:
While there are many types of tables, there are a few ways to quickly find what you are looking for:
Left Hand Navigation Menu
If you know the specific type of table you are looking for, you can navigate through the Left Hand Navigation Menu. Please note, if you do not know the categorization of the type of table you are looking for, this may be difficult to find. Feel free to check a related article on the type of table you are looking for to find out how to navigate to that specific table, or use the quick navigation menu listed below.
Quick Navigation Tool
If you know the type of table you are looking for, you can use the Quick Navigation Tool to search for the table type. When you click on the type, you will be navigated to the table for that type.
- For Example: You want to navigate to an Order table to search for a specific order. You can navigate to the dot menu and search “Order”. When you select “Order” within the modal, you will be navigated to the Order table.
Table Structure
Rows
Each table consists of multiple rows, which each represent an item of a specific data type (the table type and data type are the same, so if you are viewing an “Item Table”, each row will represent a single item). This can be an item, an order, a substitution plan, etc.
Example Item Row:
You can adjust the number of rows per page at the top or bottom of the page. If there are multiple pages, you can toggle the rows to look at other rows of pages. The page will display the range of rows that you are viewing:
Columns
Each table has columns, which include a header across the top of the table labeling the data within that column. Each column displayed is a field for the data type for the selected table. These can be adjusted to show or hide additional information.
To Do This, select “Columns” and turn the columns you do not want to see “off”, or turn the columns you do want to see to “on”:
You can drag and drop the columns to change the order in which they are displayed. You can also pin columns to the left or right of the table. This can come in handy if you want to focus on a few fields:
Filters
You can add filters, which allow you to narrow down the data displayed within the table to a specific data set.
- For Example: If you want to find a specific Item record, go to the Item table. Set the SKU filter to equal your Item SKU. This will return the results for only the specific item you were looking for:
Basic Filters
Basic Filters allow you to quickly create a filter based on a single query parameter. You can add multiple basic filters, each targeting an individual field:
To show the basic view, ensure the “Basic” toggle is selected on the far right side of the screen:
Advanced Filters
Advanced Filters allow you to create a single filter based on multiple query parameters for more dynamic filtering. To use this, toggle the Filter view to “Advanced”. You will then see a “Filter Builder” become available:
Add any necessary queries, then click out of the Filter Builder modal for the Filter to apply to the table data.
- For Example: You want to have a single filter that filters the data based on both Stock Status and Warehouse. You can use the Advanced filter and add each query to the filter.
You can add filters from a Joined Table to filter by as well. To do this, select the “Add Filter” button, then select any of the fields underneath a bold header. The bold header will indicate that the field is from a separate table, but can be joined to the current table:
For more information on filters, check out the How to Use Filters article!
Sorting
You can sort the table rows by any of the fields for the table type. This will make it so every line will be sorted in either ascending (up arrow) or descending (down arrow) order by the field selected.
For other resources and articles mentioned above, check out the related articles below: