Reporting Rows
- Fix – Override Default Format would not always work if the number value was below 1000
- Fix – Styling for Descriptions and Amounts would not always be applied to the correct column positions if an unusual layout is employed. For example, having Descriptions in the middle and many hidden outputs.
Web Channel
- Fix – Prompt label spacing was depending on the number of files would sometimes be too close the preceding filter prompt. Now has consistent 4px left spacing.
- Fix – Tree Icons no longer displayed due to a recent change in 7.1.
- Add – The REST API for displaying Icons now supports custom images located in the C:\ProgramData\Sharperlight\Metadata\Custom folder. Supported image formats are png, jpg, gif and svg. For example, /Image?icode=car-red.png or if the files are in a sub folder called Products /Image?icode=/Custom/Products/car-red.png If file extension is omitted then it will be auto detected by testing the file system until one of the four support file extensions is found.
Fix – Charts did not support custom fonts and would always display using the Arial font.
Query Builder
- Add – Expressions that return Icons using the prefix “_icon:<IconName>” can now also reference custom Icons located in the C:\ProgramData\Sharperlight\Metadata\Custom folder. Supported image formats are png, jpg, gif and svg. If there are sub folders under custom then the expression will need to specify the path. For example, “_icon:/Custom/Products/car-red.png”
Studio
- Add – Table Folders Export and Import under the Tools menu. This exports the display folder hierarchy structure in Studio to a CSV text format. The data can then be edited in Excel and then reimported into Studio replacing the existing hierarchy structure of folders and tables. This method helps with the bulk editing and organising tables into Folders which if done via the UI would take longer. The table and folder hide conditions can also be set. For example, hide tables or folders when a license feature key is not present etc. e.g. _FKEY:DM_SALES,DM_MANF
- New – Condition Hide shorthand keyword to enable easier hiding and showing of Folders, Tables and Fields based on the presence or absence of key words in license feature key. For example, _FKEY:DM_SALES,DM_MANF would only show the object if the license feature key contains either DM_SALES or DM_MANF. Previously this would have had to be done with a long Expression in the form of {_Product.Serial.Features.Contains:DM_SALES}=0 AND {_Product.Serial.Features.Contains:DM_MANF}=0. Note: the tag {_Product.Serial.Features.Contains:CODE,CODE(n)} now supports comma delimited feature key words matches. This are handy when restricting data access in addition to hiding tables by putting the following into the Root Table Where clause ##IF( {_Product.Serial.Features.Contains:DM_MANF,DM_SALES}=0 )11=22 /*Module Restricted*/ ##ENDIF