Getting user timezone and time format from MDM system tables.
Article ID: KB0094377
Updated On:
| Products | Versions |
|---|---|
| TIBCO MDM | - |
| Not Applicable | - |
Description
Description:
How to get users timezone and time format from MDM system tables.
Symptoms:
N/A
Cause:
N/A
Environment
TIBCO MDM 8.X
Resolution
Get the enterprise ID of the enterprise.
select id from enterprise where name = '<enterprise name>'
Get the member id of the user from the member table.
select id from member where username = '<username>' and enterpriseid = <enterpriseid>
Get the time zone and format information from the domainvalue table.
select * from domainvalue where owneridid = <memberid>
select id from enterprise where name = '<enterprise name>'
Get the member id of the user from the member table.
select id from member where username = '<username>' and enterpriseid = <enterpriseid>
Get the time zone and format information from the domainvalue table.
select * from domainvalue where owneridid = <memberid>
Issue/Introduction
Getting user timezone and time format from MDM system tables.
Feedback
Yes
No
Powered by
