Announcement

Collapse
No announcement yet.

Time Based Milestone Query

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • Time Based Milestone Query

    I am trying to test a time based milestone which uses a saved query to retrieve the timeout time. Unfortunately everytime the query runs (viewed through the system logs):

    java.sql.SQLException: ORA-00911: invalid character java.sql.SQLException: ORA-00911: invalid character at oracle.jdbc.dbaccess.DBError.throwSqlException

    The query shoulds a date field from the database. Does anyone have experience on using time based milestone which uses a saved query to retrieve the expiration date?

  • #2
    Re: Time Based Milestone Query

    Hi,

    Even I am facing the same issue.

    Comment


    • #3
      Re: Time Based Milestone Query

      I believe we are trying to fulfill a similar requirement.

      We want the Milestone Monitor to factor in a Calendar of M-F 8am-5pm when it is considering the date and time for the grace period should expire.

      Does anyone have any insight?

      Comment


      • #4
        Re: Time Based Milestone Query

        Hi bfolan

        I couldn't understand your exact problem. Hope you need to retrieve time from the saved date to use it as a milestone to check. Am i right?.

        If i am right use the following query to retrieve time.

        select TO_CHAR(DATE COLUMN,'fmHH24:MI:SS') from TABLE NAME where shipment_gid = 'DOMAIN.SHIPMENT NO' ;

        If am wrong kindly clarify me pls.

        Comment


        • #5
          Re: Time Based Milestone Query

          Use the time retrived in this query to check the condition of expiry.

          Comment

          Working...
          X
          😀
          🥰
          🤢
          😎
          😡
          👍
          👎