Skip to main content
B
bihitakd0001
June 22, 2022
Question

Timer Event Set up Query

  • June 22, 2022
  • 6 replies
  • 0 views

Hi Team,

I need to set the timer which shall run at 4.55 am every day and get data from view which has range query 5am last day to 5am current day when the job ran, but it is not getting the data even though all timer are set right in PM and in range query of DB.

The process gets executed at 4.55 am but it does not get data , but when we check view manually it gets the data.

So at what time zone this PM is running? And what time zone DB is running? is it GMT

I am little bit confuse that shall I un-check this box "Override with Initiator's Time Zone"  as it is by default checked.

Regards

Bihitak

    6 replies

    harshitb6843
    harshitb6843
    June 23, 2022

    Appian always stores time in DB in GMT 00 and when it is queried, it is auto casted in the user's own timezone. 
    Your process might be running the timezone where process model was published. 

    Also, by any chance, do you think you are using loggedInUser() in the query in process model?

    B
    bihitakd0001Author
    June 23, 2022

    Hi Harshit,

    Thanks, I am not using loggedInUser().

    I want to run PM at GMT time zone 4.55am and not the PM publish time zone, what shall I do for that ?

    Shall I uncheck this  "Override with Initiator's Time Zone" in PM properties?

    Regard's

    Bihitak

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 23, 2022

    Be aware that calling loggedinuser() inside a process returns the primary admin user. When someone changes the timezone for that user you might have a new problem.

    Uncheck "Override ..." and define the process timezone according to your needs.

    Terms & ConditionsAccessibility statement