Query Builder
- Fix – Issues with single filters and IN and NOT IN logic where prefix is << or <<! The not in logic did not work when filters were set to single value input e.g. <<!A,B,C This would be rare but it is now supported. Also, the values would drop out of the Query Builder Filter area when refreshed.
- Fix – Double clicking query files would not show the query details if the Company was invalid. Now asks to fix Company.
- Fix – Dynamic Output Expressions would not reference Sub Query sub outputs that were also put of the Dynamic Output section.
Explorer
- Fix – Obscured output were display when they would have been hidden
Excel
- Add – Writeback values can now reference System Properties by using the prefix SysProp:<Code> E.g. SysProp:CurrentPeriod
- Add – Writeback values can now reference Shared Authentication Library Properties by using the prefix AuthRef:<PropertyName>:<Code> E.g. AuthRef:UserName:MyAuthName and AuthRef:Password:MyAuthName
Remote Connection
- Fix – On very large queries that use Unions it was possible to get an error Maximum String content length Quota (65535). This Quota length has now been increased to -2147483648