Integrations and APIs for Service

Get Involved. Join the Conversation.

Topic

    Padma Prabha Varadarajan
    Get TimeZone Value
    Topic posted February 25, 2019 by Padma Prabha VaradarajanGreen Ribbon: 100+ Points, tagged Connect PHP, Custom Process Models - CPMs 
    74 Views, 1 Comment
    Title:
    Get TimeZone Value
    Summary:
    Fetch TimeZone using ROQL
    Content:

    Hi,

    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

    Padma

    Version:
    Oracle Service Cloud, 18C

    Comment

     

    • 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.