If you experience SQL timeouts when trying to view the list of Sent shipments, we suggest trying one of the options described below. The timeout message will usually say something like this, depending on your specific settings:
SELECT DISTINCT top 1000 Shipment.shi_ID, name1_receiver, postCode_receiver, streetAddress1_receiver, city_receiver, pro_name, shi_dateTransmit, car_fullName, shi_ref_OrderNumber, sub_ID FROM Shipment INNER JOIN fnTextSearch2(N'' , N'893218' , N'' , N'' , N'' , N'' , N'' , N''
Changing the Sent view
Loading a lot of data may cause the SQL database to time out. Try to decrease the number of columns on the page to make it load faster.
- In the Sent view, right-click and choose Field Selector.
- Choose which columns you want to display in your view. Remove tics from the list to display fewer columns.
- The Allow filtering option makes it possible to filter on the content in the columns. However, this option will not decrease the amount of data to load.
- Click OK to save your settings. Note that these changes only apply to the client.
Limit items
If changing the number of columns doesn't help, you can limit the number of items displayed in the Sent view.
- Go to the Sent view, right-click and choose Limit items.
- Per default, the Sent view will contain data from the last 90 days and show up to 1000 shipments. Large volumes may cause some SQL databases to time out. Try to set the number of days to 30 and the number of items to 100 to see if it solves your problem. You can always adjust the values.
- Click OK to save your settings. Note that these changes only apply to the client.
Using search
If you are looking for a specific sent shipment, another option would be to use Search. This feature doesn't require any additional settings and you automatically limit the large volume but using the search options.
- Go to Search and enter the information you want to use in your search. You may include various shipment information and time range.
