OpenACS Users & Groups PL/SQL API

For reference please see the users & groups data model.

 

Shortcut Functions for Users

 

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 PL/SQL API

 

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 PL/SQL 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 PL/SQL API

 

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
  Contact Us
  Project Open Business Solutions S.L.

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