Configure Settings for Large Tables

SuperWEB2 will automatically switch to large table mode if a user attempts to create a table containing more than a certain number of cells.

By default, the thresholds for large table mode are set at 8,000 rows, 1,000 columns and 100,000 total cells.

For performance reasons, we do not recommend increasing the total cell threshold above 100,000.

Configure Large Table Threshold

To configure the threshold for large table mode:

1. Open <tomcat_home>\webapps\webapi\WEB-INF\classes\configuration.properties in a text editor.

2. Locate the following section:

   XML

   #================================================================================================================
   # TABLE.LARGETABLEMODE
   #================================================================================================================
   # Integer.  Default 3.
   # Defines the number of values at each nesting level to show when you fall into large table mode.
   table.largeTableMode.previewDataSize=
   # Integer.  Default 100000.
   # SW2 will enter large table mode if the table has more than this number of cells.
   table.largeTableMode.thresholdTotal=
   # Integer.  Default 8000.
   # SW2 will enter large table mode if the table has more than this number of rows.
   table.largeTableMode.thresholdRow=
   # Integer.  Default 1000.
   # SW2 will enter large table mode if the table has more than this number of columns.
   table.largeTableMode.thresholdColumn=

3. There are three settings that determine when large table mode will be activated:

   Parameter	Enter large table mode if the table contains...
   largeTableThresholdTotal	More than this number of cells.
   largeTableThresholdRow	More than this number of rows.
   largeTableThresholdColumn	More than this number of columns.

4. You may also want to configure the previewDataSize setting. This controls the number of cells to show at each level in the table when SuperWEB2 is in large table mode.

   By default, this is set to 3 (as shown here, SuperWEB2 displays the first two values of the field and .. to indicate that there are more items at this level):

   

5. Save your changes to the file and restart Tomcat or the SuperWEB2 service.

Change the Preview String

You can also change the string that is shown in the last heading for each row and column. By default this is set to ..

1. Open <tomcat_home>\webapps\webapi\WEB-INF\classes\common_labels.properties.

   

   There may be multiple copies of this file for different languages and locales, with names like common_labels_en.properties and common_labels_en_AU.properties. Each one contains the text used for different languages. Depending on which languages are in use on your deployment, you may need to make these changes in multiple versions of the file. The properties file that is used will depend on the language settings in the end user's web browser, the set of supported locales defined in the faces-config.xml configuration file, and the language selected by the user from the drop-down list. See Multilingual and Localisation Support for more information about localisation and how SuperWEB2 uses the properties files.

2. Locate the following property:

   TEXT

    tableView.largeTableMode.dots=..

3. Change the value to your preferred string.

4. Save your changes and and restart Tomcat or the SuperWEB2 service.

Configure the Maximum Number of Cells in a Table

To configure the maximum number of cells permitted in a table:

1. Open <tomcat_home>\webapps\webapi\WEB-INF\data\.repository\RulesEngine.xml in a text editor.

   

   Make a backup copy of this file before making any changes.

2. Locate the following section:

   XML

       <rules:EditRule name="TableCellsNumberRule"
               applicableOperations="add;drillup;drilldown"
               implClassName="au.com.str.webapi.services.database.manager.rules.impl.TableCellsNumberRule">
           <rules:impl-class-init>
               <rules:init-param name="maxElementCount" value="40000000"/>
               <rules:init-param name="disableMaxElementCount" value="false"/>
           </rules:impl-class-init>
       </rules:EditRule>

3. Change the value of maxElementCount to your preferred maximum number of cells.
4. Save your changes to the file and restart Tomcat or the SuperWEB2 service.

Prevent Guest Users from Accessing Large Table Mode

If you have enabled guest user access on your system, you may also wish to prevent guest users from accessing large table mode. See Prevent Guest Users from Creating Large Tables for more information on this step.