Topic
  • 3 replies
  • Latest Post - ‏2014-02-06T08:01:08Z by ExInEx
JuanRomero
JuanRomero
14 Posts

Pinned topic using datetime atributes at a workflow

‏2014-02-04T21:54:57Z |

 

Hi everybody
 
We are creating a workflow that at some point will compare the ticket's "creation date" atribute versus the ticket's "start date" atribute.  We want to compare the dates or the days not the datetime atribute itself.
 
We are having some issues at the conditional node:
 
 When we add the following code to the expresion, we are getting SQL -245  error  (-245 THE INVOCATION OF FUNCTION routine-name IS AMBIGUOUS):
 
date(:reportdate) <> date(:actualstart)
 
We changed the code as below.  This way allowed  us to have the expresion without errors and to activating the process. However at the moment of applying the process on a record we are getting  some errors.
 
date(to_date(:reportdate)) <> date(to_date(:actualstart))
 
 
what should we do in order to compare datetime attributes at a conditional node ?
 
We really appreciate any help you can give us
 
Best regards
 
Juan Romero
Updated on 2014-02-05T12:59:26Z at 2014-02-05T12:59:26Z by JuanRomero
  • ExInEx
    ExInEx
    88 Posts

    Re: using datetime atributes at a workflow

    ‏2014-02-05T04:01:43Z  

    Hi,

    I've create a new workflow which is referring to SR object and tested the expression below was returned as successful.

    :ticket.reportdate <> :ticket.actualstart

    Tested environment:-
    OS: Windows 2008 R2
    DB: DB2 9.7
    WAS: WebSphere 7.0.0.17

  • JuanRomero
    JuanRomero
    14 Posts

    Re: using datetime atributes at a workflow

    ‏2014-02-05T12:54:35Z  
    • ExInEx
    • ‏2014-02-05T04:01:43Z

    Hi,

    I've create a new workflow which is referring to SR object and tested the expression below was returned as successful.

    :ticket.reportdate <> :ticket.actualstart

    Tested environment:-
    OS: Windows 2008 R2
    DB: DB2 9.7
    WAS: WebSphere 7.0.0.17

    Hello DEOCK YONG SHIN

    The expression ":ticket.reportdate <> :ticket.actualstart" works but it does not help us with the outcome we want to obtain.

    We want to compare days or dates. we want to extrac the date from the datetime atribute and just then, compare  the dates.

    We have not managed to have this condition right and running. 

    Best regards,

    Juan Romero

     

     

     

     

     

     

  • ExInEx
    ExInEx
    88 Posts

    Re: using datetime atributes at a workflow

    ‏2014-02-06T08:01:08Z  

    Hello DEOCK YONG SHIN

    The expression ":ticket.reportdate <> :ticket.actualstart" works but it does not help us with the outcome we want to obtain.

    We want to compare days or dates. we want to extrac the date from the datetime atribute and just then, compare  the dates.

    We have not managed to have this condition right and running. 

    Best regards,

    Juan Romero

     

     

     

     

     

     

    Hi Juan,

    In Expression, not seems to be able to use EXTRACT or casting kind of keyword. Will let you once I found a resolution for this.
    Thank you.

    *In case you are not getting your answer then I would recommend to open a PMR (if you or your company have the IBM Value Package) with IBM support.
    IBM Value Package
    http://ibm.com/partnerworld/wps/servlet/ContentHandler/pw_com_vpo_value_package
    Submit your PMR here
    http://ibm.com/isv/tech/remoteEmail/entryForm.jsp