Browse FAQs

Limiting the default number of records returned for a Historic Search in ClearSCADA

Published date: 16 November 2019

You can use the ClearSCADA Server Configuration Tool to define the search limits for historic searches. This is useful as it allows you to define the size of searches so that searches for historic data do not put a high demand on the server.

To define the search limits, you need to use the Search Limits section in the Historic branch of the ClearSCADA Server Configuration Tool as following:
  1. Access the ClearSCADA Server Configuration Tool.
  2. Expand the Historic Configuration branch.
  3. Select Search Limits.


     
  4. In “Maximum Records”, You can change the maximum number of records that can be included in a single historic query to 10,000.  (The default setting of 100,000.)
  5. When displaying Historic list Query, You will notice that the default number is changed in the SQL statement as shown:


For more information on the other Historic settings, refer in ClearSCADA Help Manual to the list of features through below path :

System Administration > Server Administration > Historic and Archive Data > Historic Configuration Settings



 

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.