Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Preference setting for Spotfire Desktop to MarkingWhereClauseLimit and MarkingInQueryLimit.

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Preference setting for Spotfire Desktop to MarkingWhereClauseLimit and MarkingInQueryLimit.


Solution:

When you have large/complex data tables which are related, then in such a scenario you may face an error "Filtering in related table could not be applied" error and the related table will not be filtered.

For the Spotfire Analyst, we are able to set the preference setting for MarkingInQueryLimit (Default is 15000), MarkingWhereClauseLimit (Default is 1000) from the Administration Manager, however, for the Spotfire Desktop version there is no Administration Manager for making change to this preference setting.

Description of preferences:
  • MarkingInQueryLimit - Limit applicable for queries within a single column. Specifies the limit for how large queries should be allowed when marking or transferring markings or filterings between related tables. The default is 15000.
  • MarkingWhereClauseLimit - Limit applicable for queries involving multiple columns. Specifies the limit for how large queries should be allowed when marking or transferring markings or filterings between related tables. Default is 1000.
     

Please follow the steps as given below to add the setting in the configuration file:

*Note: Please make sure you have a backup copy of the "Spotfire.Dxp.Main.dll" config file before you make changes to it.

Browse to the below-mentioned directory of the Spotfire Desktop which contains the AppData and configuration files for Spotfire Desktop.

C:\Users\(YOUR_USER_NAME)\AppData\Local\TIBCO\Spotfire Desktop\7.11.0\Modules\Spotfire DXP Forms_32.0.11802.4673

In the above directory, you can find the "Spotfire.Dxp.Main.dll.config" file, please have the backup copy of this file before you make changes in the setting for this file.

Open the "Spotfire.Dxp.Main.dll.config" file in a text editor, and add the following XML code in between the <applicationSettings>  </applicationSettings> tag.

<Spotfire.Dxp.Data.Properties.Settings>
    <setting name="Desktop_Preference_MarkingWhereClauseLimit" serializeAs="String">
      <value>1000</value>
    </setting>

    <setting name="Desktop_Preference_MarkingInQueryLimit" serializeAs="String">
      <value>15000</value>
    </setting>
</Spotfire.Dxp.Data.Properties.Settings>

*Note that these are the default values. You need to increase these values in order to resolve the issue that you are facing.

Save the above changes in the "Spotfire.Dxp.Main.dll.config" file and relaunch the Spotfire Desktop instance.

You can check by sufficiently increasing those values for "Desktop_Preference_MarkingWhereClauseLimit" and "Desktop_Preference_MarkingInQueryLimit" resolves your issue.

*NOTE: Changing these preferences may have a negative impact on performance. Increase the values with caution.
 
https://docs.tibco.com/pub/sfire-analyst/7.7.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/data/data_working_with_large_data_volumes.htm

Related articles