Can time spans be applied on data partitions?

book

Article ID: 15584

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Data Partition constraints and stored queries share similar aspects and resemblances.  Users may try to use Timespans (Eg. PAST_WEEK, TODO_TODAY, LAST_MONTH) in data partition constraints.



Is it possible to use timespans with data partitioning?

Environment

CA Service Desk (all versions)

Resolution

Data partitions are a functionality that apply a specific condition alongside a given backend SELECT statement, similar to Stored Queries.  That additional entry to the SELECT statement WHERE clause will only support a time span from one location, which is the Stored Queries.  This is by design as what can happen is two separate where clauses, one from Stored Queries and the other from Scoreboards, that both have had time spans entered, which can cause confusion in the where clause layout.

An unsupported method to workaround this would be to include spel code that would flag a given ticket as viewable depending on the time of day.