Bootstrap

#Query Builder

Version 5.2.39

Query Builder Fix – Sub Queries filter would become incorrect on rows after being passed <<!  Not in listFix – System Web Table, JSON, XML would return an error if an empty JSON array w[...続きを読む]

Version 5.2.35

Query Builder Change – Increase row limit on System tables such as CSV, JSON, XML, Web Tab, Excel, Windows Event Log, LDAP and MS Teams.  Fix for v5.2.33 got SQL error when no dataFix – Sub Q[...続きを読む]

Version 5.2.33

Query Builder Change – Increase row limit on System tables such as CSV, JSON, XML, Web Tab, Excel, Windows Event Log, LDAP and MS Teams.  Previously it would max out at 1,000 rows but can now[...続きを読む]

Version 5.2.31

Query Builder Fix – Filter Mapping did not work correctly when used in combination with multiple Company or Business Unit filter selections.Fix – new Output Sub Queries were not showing Expression[...続きを読む]

Version 5.2.29

Query Builder Add – When opening a Materialised Query that is associated with a Database that is not valid, a prompt now appears to allow the Query to be redirected to another MQ Database.  T[...続きを読む]

Version 5.2.27

Query Builder Add – Output Expressions can now be used as filter parameters in Sub Queries.  Previously the only way to calculate a value was by using Filter Expressions e.g. _Expression( ) w[...続きを読む]

Version 5.2.3

Publisher Fix – Google Map Layers did not always work correctly when displaying pins with labels and did not show any pins due to a JavaScript error.  This was recently introduced.Add – Googl[...続きを読む]

Version 5.1.90

Query Builder Fix – Dynamic Columns based on Dates with a Year/Month function applied to them would not work correctly in Excel if dates were referenced in cells instead of text in YYYY/MM format.[...続きを読む]

Version 5.1.85

Command Line Change – Saving Published Reports to Excel xls, xlsx will create a standard list instead of using a Page Designer layout unless one is present.  This is a better format as there [...続きを読む]

Version 5.1.78..79

Query Builder Fix – Filter <in> criteria would drop when reopening Query Builder.  This issue was introduced in 5.1.78.Fix – Filter Mapping of Company or Business Unit selection in Exce[...続きを読む]

Version 5.1.50

Query Builder Fix – Multiple Company / Business Unit selection did not work correctly when passed to a sub query.  This regressed in a recent 5.1.4x build.

Version 5.1.41

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.&nb[...続きを読む]

Version 5.1.40

Scheduler Fix – FTP did not display the file details when reopening and editing an Action.  Action would work correctly but editing the file setting would require you set it again.Add – File [...続きを読む]

Version 5.1.38

Scheduler Add – SFTP action now support Public Authentication Key Files Add – JavaScript SFTP library Create Function now supports third parameter for Public Authentication Key data Shar[...続きを読む]

Version 5.1.30

Query Builder Add – Expressions to match Financial Functions found in Excel   PMT, IPMT, PV, FV and DDB Command Line Fix – ProductSettings issue with Quotes on parameters causing a[...続きを読む]

Version 5.1.24 to 28

Publisher Add – Google Map Layer now has a new optional output field called Select (Boolean) which allows one to select rows by default so they are bouncing or marked with a yellow arrow on load b[...続きを読む]

Version 5.1.23

Web Channel Fix – _Expression() sometimes appeared unresolved in Filter if it referenced a visible filter’s value.  Now encodes as inline _Expressions( ) are not allowed in filters in the Web[...続きを読む]

Version 5.1.16

Foundry New – Field Advanced Options Writeback Grid Column Width Web Channel Fix – Permissions error on main Index page due to access to windows/temp folder being blocked.Fix – Hidden Filter[...続きを読む]

Version 5.1.8

Foundry New – Field Advanced Options now allows a Default Format to be applied to Dates and NumbersNew – Input Style Number SpinnersNew – Input Style Number Slider.  Note use the Validation f[...続きを読む]

Version 5.0.99

Command Line New – /ProductSettingsSet Allows the setting of Site Setup / Product Settings via the command line.  (See online article for details)New - /RemoteConnectionSet Add, Update and De[...続きを読む]