CA Service Management

  • Private Community
 View Only

  • 1.  data partition constraint - use of date's

    Posted Nov 09, 2017 05:38 AM

    Is it possible to create a constraint like this: open_date > now() - 1 year



  • 2.  Re: data partition constraint - use of date's

    Posted Nov 09, 2017 06:20 AM

    hi,

    you can use timespans (Admin tab > Service Desk > App Data > Codes > Timespans), followed constraint should work:

    open_data >= StartAtTime(\'PAST_YEAR\')

    Regards,

    cdtj



  • 3.  Re: data partition constraint - use of date's

    Posted Nov 09, 2017 07:05 AM

    Hi 

    open_date >= StartAtTime(\'PAST_YEAR\')

    This method works fine with stored queries, but not in data partition constraints.

     

    I get the error-message:

    AHD05800:Bad where clause. invalid constraint. Check data types of referenced attributes

     

     

    regards

    Børge



  • 4.  Re: data partition constraint - use of date's
    Best Answer

    Posted Nov 09, 2017 07:19 AM

    have you tried query without escalation?

    open_date >= StartAtTime('PAST_YEAR')


  • 5.  Re: data partition constraint - use of date's

    Posted Nov 09, 2017 07:27 AM

    Good point. (Of course).

     

    That work's.

     

    Thank you.