Publisher
- Add – Google Maps Layers in addition to the Chart type of Maps Normal and Heat Maps. Map Layers allows for the create of Google Maps with overlays using any of the follow types of objects: Marker, Symbol, Label, TextBox, Polygon, Polyline, Circle, Box, Heat, Kml, Kmz and GeoJson. Use Query Builder to create output columns with the following names to drive the logic: Type, Position, Label, Title, Content, Color, Style, URL, Visible, Value and Range. Any outputs that do not match these names are turned into flat or hierarchical Filter slicers so that individual points or series can be selected, removed or display. The Range Output is displayed as a numeric range selector similar to what is seen in price range sliders on shopping sites. This new chart type is compatible with Query Builder outputs that target Normal and Heat Maps.
- Add – Resources can now be accessed as a URL. The URL link is now displayed on the Resource Edit Window when the Resource is selected. This is useful with included GeoJson, KML or KMZ files to load into Google Map Layers.
- Add – Chart tab now shows preview image of Chart type
Web Channel
- Add – Filter wild card search in dropdowns at any time by prefixing % or ** on the front of the text being searched. The match is case insensitive and will look for any occurs of the character sequence in both the code and description. The method can be used in both Report Filters, Form Entry and Grid Entry
- **A56 (Will search for A56 in the code or description)
- %A56 (Will search for A56 in the code or description)
- %A56%X (Will search for A56%X in the code or description)
CLI
- Add – Initialize existing blank Sharperlight by creating required table objects if required. Any errors if present are returned in the Windows Event Log.
- md.Applications.exe /InstallDatabase
- Add – Start, Stop or Restart all Instance Management enabled Sharperlight Services including the primary/master instance with the specified delay between each service. The default delay time in seconds is 2 seconds after stop and 5 seconds after start. Information and errors are shown in the Windows Event Log.
- md.Applications.exe /ServiceSetAll mode:Restart DelayStartSec:5 DelayStopSec:2 IncludeMaster:Y
- md.Applications.exe /ServiceSetAll mode:Start DelayStartSec:5 DelayStopSec:2 IncludeMaster:Y
- md.Applications.exe /ServiceSetAll mode:Stop DelayStartSec:5 DelayStopSec:2 IncludeMaster:Y
- Add – Start, Stop or Restart the specified Sharperlight Instance Management Window Service the specified delay. The default delay time is 20 seconds.
- md.Applications.exe /Instance:239f /ServiceSet mode:Restart Delay:20
- md.Applications.exe /Instance:239f /ServiceSet mode:Start Delay:20
- md.Applications.exe /Instance:239f /ServiceSet mode:Stop Delay:20
- Add –Start or Restart Sharperlight Primary/Master Window Service.
- md.Applications.exe /ServiceRestart
- Add –Install Sharperlight PowerBI add-in into PowerBI desktop editor
- md.Applications.exe /PowerBiInstall
Engine
- Fix – Periods based on month names did not work correctly for July. In version 5.0 only period numbers 2020/05 were accepted but in version 5.0.60, it introduced period months 2020 May