• State Verified Answer
  • Replies 2 replies
  • Subscribers 95 subscribers
  • Views 164 views
  • Users 0 members are here
Options
Related

Obtain Person (or system default) UID_DialogCulture

hector bernal
8 days ago

Environment: 1IM 9.2

We need to provide an external REST API consumer with Person data including Culture information for every active Person in our database.

For this we created a a ReadOnly View that contains Person and QBMCulture info among others (exposed through api/entities endpoint in App ServerREST API),

In the process we found UID_DialogCulture is only written in Person records when a language is manually selected, how can i get default system Culture for the rest of the records ? Using SQL if posible.. 

Thks in advance

Hector  

Parents
  • +1 7 days ago

    You can use the SQL function QER_FGICultureForPerson for this. It takes a UID_Person as input and returns the UID_DialogCulture, which the system determines as the culture for use.

  • 0 6 hours ago in reply to Markus Weiss-Ehlers

    this allows to do nice things like 

    INNER JOIN QBMCulture cult ON cult.UID_DialogCulture = CASE WHEN (person.UID_DialogCulture is null)
                                                                                                    THEN dbo.QER_FGICultureForPerson(person.UID_Person)
                                                                                                    ELSE person.UID_DialogCulture END

    thks Markus !

Reply
  • 0 6 hours ago in reply to Markus Weiss-Ehlers

    this allows to do nice things like 

    INNER JOIN QBMCulture cult ON cult.UID_DialogCulture = CASE WHEN (person.UID_DialogCulture is null)
                                                                                                    THEN dbo.QER_FGICultureForPerson(person.UID_Person)
                                                                                                    ELSE person.UID_DialogCulture END

    thks Markus !

Children
No Data