Home » Categories » Solutions by Business Process » System Features

Landing Pages - Fast Sort Record Selection

When using the Landing Page against larger data sets then options to bring in the last X thousand records added can be used against Sales Order, Purchase Order or Works Order landing pages to speed up processing and display. On these applications the ‘active’ records to be processed will more than likely be in the block of orders recently added.

 

For the Sales Ledger, Purchase Ledger and Stock applications the active records could be anywhere in the file meaning selection criteria has to read all records to determine the active list which can take time to process. This new feature allows you to set a ‘fast sort’ selection on the landing page to identify the active records more quickly.

 

Landing Page Properties

 

To define a ‘fast sort’ selection select the required landing page and choose the Landing Page Properties. Once displayed select the ‘tool’ icon at the top right of the properties display to access the Advanced Properties.

The Advanced Properties have three tabs.

 

Grid Behaviour allows you to set the action that is triggered if double-click a record. You also have display properties that can set as required.

 

Date Properties allows you to set end working day, the date on which the weekends and set the working days. This is used for the Calendar ‘Explorer’ style views.

 

Fast Sorter is the new options that allow you to set as part of the index build the criteria for the records to be displayed. The initial display shows a blank list allowing you to ADD a filter.


Field – select the data item from the drop-down list. Items allowed are those defined within the set-up option ‘Define Extra Fields to Load’.

 

Operator – select the selection type. If using a date item options are available to select for this/last year etc. but remember this is calendar not financial year.

 

Compare Against Fields – select if looking to compare one data item against another. Leave blank to enter a value.

 

Value – enter the value to test against.

 

Case Insensitive – if testing a text item set to ignore case when applying the filter.

Once defined click OK.

 

You can add more than one filter, but each filter must be met for the record to be displayed.

 

 

Notes

 

The Fast Sort filter is held against the users landing page configuration. Where appropriate you can use the COPY function to update one user landing page configuration to another.

 

To improve speed further you should restrict the ‘Define Extra Fields to Load’ to just those items required – only include those items needed for the landing page or data visualisation tools.

Custom Fields
  • Release ID: 7.4
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Job Costing Category Analysis
Viewed 3149 times since Tue, Jun 12, 2012
Application Pick Lists - Apply Colour Highlighting Rules
Viewed 1638 times since Wed, Sep 21, 2016
F8-Zoom - Allow Other Searches and Enquiries
Viewed 3957 times since Fri, Jun 8, 2012
Datafile Software - Menu Application Files
Viewed 2211 times since Wed, Jun 13, 2012
Ledger Enquiry Links to Discount and Supplier Matrix
Viewed 1623 times since Fri, May 20, 2016
Application Memos – Warning or Note
Viewed 1048 times since Wed, Jun 13, 2012
T-Table Description as Data Item
Viewed 1836 times since Wed, Jun 13, 2012
Log User-Id / Date / Time Database Record Updated
Viewed 3206 times since Fri, Oct 26, 2012
Alternate Image Viewer
Viewed 1648 times since Mon, Nov 25, 2013
History Database Cross-Links
Viewed 2079 times since Tue, Jun 12, 2012