Error when using custom expressions editor with multiple tables in a visualization

Error when using custom expressions editor with multiple tables in a visualization

If your .dxp file has two related data tables, and those tables have columns which have the same name, but different case (upper vs lower), then when trying to use these two columns in a custom expression, the custom expression tab may fail to recognize the correct table resulting in errors in the expression when the expression editor is closed. For example, the column name may have some or all characters in upper case in one table like "MyColumn", and a differing case in the second table like "mycolumn".
This is caused by a defect which has been fixed in hotfix TS_10.3.1.13 LTS HF-004, 10.3.2, and in versions 10.4 and higher.

To resolve, please download and apply client hotfix 10.3.1 HF-004, or upgrade to versions 10.3.2 or 10.4 or higher. Doc: Details on Custom Expression

• https://docs.tibco.com/pub/sfire-analyst/10.3.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/ncfe/ncfe_details_on_custom_expression.htm

Wiki: List of hotfixes for TIBCO Spotfire® Clients (Analyst, Web Player (Consumer/Business Author) and Automation Services) > TS-60299 - Expressions referencing secondary tables sometime got wrong casing after closing the custom expressions editor

• https://community.tibco.com/wiki/list-hotfixes-tibco-spotfire-clients-analyst-web-player-consumerbusiness-author-and-automation#103