Time Based Milestone Query

[bfolan]

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?

[muthaharotm]

Re: Time Based Milestone Query

Hi,

Even I am facing the same issue.

[joecallan]

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?

[Sophia]

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.

[Sophia]

Re: Time Based Milestone Query

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