| AyaNova is actually busy get all records for that grid to display - a crash is not occurring. What is occurring is that when you select the Custom Fields grid to display from the Service navigation pane, an hourglass occurs as what is happening : as the Custom Fields grid is not filtered, a request for every workorder item in every service workorder is being displayed - as a custom field is possible for every workorder item. There are two situations here: 1. As no filters are set for this grid, all possible records are being queried to display. What is recommended is to place a filter on at least one column to restrict the number of displayed rows - as you probably don't need to view every workorder item ever created. For example, select the filter image on the Service Date column and select [Window - 14 Days] so it shows only records that have a Service Date between 7 days ago and 7 days ahead. Or select [Month - Current] to show records with a Service Date that fall in this month. You can set as many filters on as many columns as needed. We do have it listed in the Wish List and on our own internal list of features to add - the ability that default grid settings and filters could be assigned to users when they first log in. In this way a new user would not get every workorder ever made and have to make a filter. We also have on the Wish List to include the ability to be able to easily select "saved" views (filters already selected, column order already defined, etc) 2. Are you presently running the default setup - single AyaNova installation using the default embedded Firebird server? AyaNova users with a lot of data are encouraged to utilize the network Firebird configuration or the SQL Server network configuration. The default installation utilizes the embedded Firebird server which many small companies either starting to use AyaNova, or with small number of workorders will find more than fast enough for their needs, in addition to not needing any additional configuration. Instructions for installation and configuration for AyaNova use with the network Firebird server is outlined in steps in the AyaNova v3 Manual section "Installation of AyaNova with the network Firebird Server" starting on page 536
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|