There are a number of parameters that can be modified for the query components.
Most are set to a default value which will typically suffice, but occasionally one might
need to be customized. For example there is a configuration parameter that controls
the maximum number of rows that can be returned by a query. This parameter is Queries.SetSize.Maximum
and is set to a default value of 500000. Another parameter determines whether
or not a warning dialog is displayed when a filter is deleted. This parameter is DeleteFilterWarningDialogEnabled
and is set to a default value of true.
To set these configuration parameter values, the file
"Configuration.properties" must appear to be in the com\sas\query package.
This could be done by modifying the jar or zip file from which you are getting the query
components. There is an empty version of this file in the queryAF.jar file that ships with webAF. For this example we will assume you are on a windows machine and have chosen to set some configuration values in this file.
In this example we'll shut off the warning message when deleting a Filter. We'll want to set the value of DeleteFilterWarningDialogEnabled to be false.
In the text file we specify the name of the parameter, follow it directly with an equal sign, and then the value we wish to assign to that parameter. For boolean values you may specify true or false. For numeric values, just specify the number (no separating commas/periods). String values do not need to be surrounded by quotes.
We'll open the jar file we are getting the query components from (open queryAF.jar with winzip). In the list of files contained in the jar we see Configuration.properties listed in the com/sas/query directory. Open this one file from the jar.
So if we wish to shut off those warning messages when we delete a filter we would put:
DeleteFilterWarningDialogEnabled=false
in the Configuration.properties file. Similarly if we want to
increase the maximum number of rows that can be returned in our queries we would add the
line:
Queries.SetSize.Maximum=500000
to Configuration.Properties.
We now save the file and update the jar file with the new file. When you next run the query components, the warning message will not be shows when deleting filters.
Note: These configuration parameters can change in the future.
Some values that you may wish to modify are listed below, together with their default
values.
Parameter=defaultValue |
Description |
Queries.DistinctValues.Enabled=true | Can distinct values be queried from Filter Edit Dialog |
Queries.DistinctValues.MaximumToReturnSpecified=true | Do we specify a maximum number of distinct values to be returned |
Queries.DistinctValues.MaximumReturned=250 | If above is set, what is the maxiumum |
WebAfDataSource.DistinctValues.Inobs=10000 | For engines that support it, how many input records are examined when getting distinct values |
WebAfDataSource.DistinctValues.Outobs=250 | For engines that support it, how many output records are obtained when getting distinct values |
Queries.SetSize.Maximum=500000 | What is the maximum number of rows that can be returned by a query. |
DeleteFilterWarningDialogEnabled=true | Should a warning dialog be displayed before deletion of a filter |