Hello everyone,

In this sprint, we have added support for filtering date and time-based filters based on the control ID of the corresponding column.

You can read more about Indicium's features in the Indicium user manual.

We will keep you updated regularly about Indicium's progress.

About Indicium

Two types of the Thinkwise Indicium Application Tier are available:

• Indicium: for use with the Universal GUI and via APIs. This version uses the full range of Indicium functionality.
  Download Indicium release 2023.2.12 here .
• Indicium Basic: for use with the Windows GUI and Mobile GUI. This basic version does not support features such as system flows and OpenID.
  There is no Indicium Basic release for 2023.2.12.

Contents

Changed

Date and time-based filters take ‘control_id’ into account

Date and time-based filters now take into account the control ID of the corresponding column. Consider the situation where a DATETIME column has a DATE control ID. Only the date portion of the value will be filtered in this case, not the time portion. Furthermore, Indicium ensures that the filter is applied in such a way that it covers the user's intent.

Given the example of a DATETIME column with a DATE control ID, the filter condition

column eq 2023-08-21T01:01:01Z

is interpreted as "column equal to 2023-08-21", and Indicium creates a filter condition similar to

WHERE column >= '2023-08-21 00:00:00' and column < '2023-08-22 00:00:00'

in order to match all values on that day.

This feature is not yet supported by the Universal GUI, but it will be in the near future. Meanwhile, for API calls you can opt in to use this feature by adding the following query string parameter to your GET requests

?useControlBasedFiltering=true

Minor fixes and tasks

• We have fixed an issue where the Check password process flow action did not recognize the algorithm returned by the Hash password process flow action.

Questions or suggestions?