For reference please see the users & groups data model.
The following functions are frequently used to extract information about a user:
Function | Returns | Arguments | Description |
---|---|---|---|
[im_dept_from_user_id] | varchar | integer | |
[im_email_from_user_id] | varchar | integer | Shortcut function returning a user's first_names, last_name. |
[im_profiles_from_user_id] | varchar | integer | Shortcut function returning a string with a comma separated list of all profiles of a user. |
[im_initials_from_user_id] | varchar | integer | Shortcut function returning the user's intials. |
Profiles are a ]po[ sub-type of group.
Function | Returns | Arguments | Description |
---|---|---|---|
[im_profile__delete] | integer | integer | Destructor |
[im_profile__name] | varchar | integer | Name Function |
[im_profile__new] | integer | integer, varchar, timestamptz, integer, varchar, integer, varchar, varchar, varchar, varchar, varchar | Constructor |
[im_profile__new] | integer | varchar, varchar | Shortcut constructor |
[im_profile_add_user] | integer | varchar, integer | Adding a profile to a user. This function is not save, because profile membership is cached in the TCL API. |
Parties are a super-type of persons and groups.
Function | Returns | Arguments | Description |
---|---|---|---|
[party__delete] | integer | integer | Destructor |
[party__email] | varchar | integer | Shortcut function to return the party's email field. |
[party__name] | varchar | integer | Name function |
[party__new] | integer | integer, varchar, timestamptz, integer, varchar, varchar, varchar, integer | Constructor |
The following functions allows to add/remove users to a party:
Function | Returns | Arguments | Description |
---|---|---|---|
[party_approved_member__add] | integer | integer, integer, integer, varchar | |
[party_approved_member__add_one] | integer | integer, integer, integer | |
[party_approved_member__remove] | integer | integer, integer, integer, varchar | |
[party_approved_member__remove_one] | integer | integer, integer, integer |
Persons represent natural persons.
Function | Returns | Arguments | Description |
---|---|---|---|
[person__delete] | integer | integer | Destructor |
[person__first_names] | varchar | integer | Shortcut function to return the first_names field of a person. |
[person__last_name] | varchar | integer | Shortcut function to return the last_name field of a person. |
[person__new] | integer | integer, varchar, timestamptz, integer, varchar, varchar, varchar, varchar, varchar, integer | Constructor |
Calle Aprestadora 19, 12o-2a
08902 Hospitalet de Llobregat (Barcelona)
Spain
Tel Europe: +34 609 953 751
Tel US: +1 415 200 2465
Mail: info@project-open.com