Integrations and APIs for Service

Get Involved. Join the Conversation.


    Padma Prabha Varadarajan
    Get TimeZone Value
    Topic posted February 25, 2019 by Padma Prabha VaradarajanRed Ribbon: 250+ Points, tagged Connect PHP, Custom Process Models - CPMs 
    118 Views, 1 Comment
    Get TimeZone Value
    Fetch TimeZone using ROQL


    I am trying to fetch the TimeZone value of a user from ROQL.

    But unable to get any values if I say as below:

    "Select timezone from Account"

    Should I query in a different way or is there anything else to be done here.

    Please help me here. 


    Thanks in Advance


    Oracle Service Cloud, 18C



    • Sebastiaan Draaisma

      Hi Padma.

      Unfortunately the account time zone field is not available in either ROQL or analytics. The only solution I see is to create a custom field for accounts (menu type) in which you specify the time zones. This would then be accessable in both analytics and ROQL.

      An alternative is to estimate the time zone based on the country which would only work for countries with a single time zone.