]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register
 

Contents

Remote Training
Support
SaaS Service

4 registered users
 in last 24 hours

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
­

Please take a moment to complete this form to help us improve our service.

Note:
Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy