Notifications
Clear all

[Solved] time zone handling

1 Posts
2 Users
1 Reactions
2,154 Views
0
Topic starter

The following is from a report schema.

<CustomRetrievalField>

<FieldRef levelType="ShipmentHeader" category="PDF">
<FieldName>ActualPickup</FieldName>
</FieldRef>
<Hidden>true</Hidden>
<Type>DATE</Type>
<TimezoneHandling>
<ValueBased>true</ValueBased>
</TimezoneHandling>
<SimpleMapping sqlName="ACTUAL_PICKUP_DATE"/>
<Timezone sqlName="shipfrom_tz" fallbackTz="user_profile"/>
</CustomRetrievalField>

Questions are:

1.Tag <TimezoneHandling> seems not defined in Platform User's Guide (Neo 3.3) any where. Is this tag necessary since tag <Timezone> exists already?  what does it do?

2. Where is the location where user_profile timezone id is defined?  

 

1 Answer
1

Looks like TimezoneHandling is an older xml element which is rarely used.  I think since you have Timezone defined later, you can/should remove TimezoneHandling.

The user profile TZ comes from whatever that user has configured as their preferred timezone. In java, this manifests as com.transcendsys.platform.web.profile.UserProfile.getTimeZone()

In the database, it is stored in USERS.PREF_PROP_LIST

image