-
Previous Month Value
What is the best way to dynamically display the previous month's value in a table based on the displayed value? The available context calculations only allow for difference from previous,…
- Answered
-
Member Security - return default if no rows matched
We are looking to apply a security rule to a table using member security. In our security table, there is a default row that should be matched to if the user does not meet the security rules.…
- Answered
-
PQL for checking if date is null
Trying to find the correct syntax for checking if a date is null in a script formulate. Currently accessing the date via [pyramid_custom_query_t_placement_patient_hsptl].[cl_effective_from_date].…
- Answered
-
Date filters allow range and null selection
Use case: Users need to be able to select a date range (YTD 2023 for example) and also have the ability to return the rows that have a NULL date. Using the multi select dropdown is not an suitable…
- Answered
-
Renaming direct query table does not change underlying name that is used. Correct functionality or a bug?
When renaming a direct query table, the original table name is often used in other areas (security scripts, join statements as shown in attached image).…
- Answered
Latest Posts