Query Builder

  • Fix – Sub Query filters using a in clause with two items would be resolved as a SQL between instead of a SQL IN.  e.g.  <in> A,B  <<A,B   If the in clause had one, three or more items it was fine and did not use the between logic.
  • Fix – Filter using the PERIOD keyword for SunSystems were not updating the current Period when it was changed in the ledger definition within a 15-minute window.  Required a Service Restart while older versions <5.0 did refresh the current period correctly.