Home › Blogs › xhong's blog

User-defined role and event trigger 101

Wed, 2008-09-03 16:36 — xhong
0
No votes yet

This is an ABC or 101 question.
We have created a user-defined roles, such as faculty_mailing_list, which includes all faculty and a few administrators who need to know what info/news sent to faculty. We can see this role listed on Table GORIROL for those who should have this role.
We have learned that we should write an event trigger so that if a new person is qualified for this role, an event will be fired and the system will get all related info for this person and publishes to LMB.
However, we don't know where to start, on which table this trigger should be. Do any of you have similar cases? Could you please share your trigger codes with us? Any warning and tips will be greatly appreciated.
Xiaoling

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Wed, 2008-09-03 19:59 — xhong

checking

I am checking to see if any comments or suggestions or code sameples. This is my first try on lumdev. Hope there will be some responses tomorrow.

Wed, 2008-09-03 20:31 — ahoward

Triggers for LDIPERSON events

I don't have enough background information on your mailing list to know what table should have LDIPERSON triggers on it. Are you managing the list in Banner somehow? In that case, the table in which the person is associated with the list is the one that should have the triggers.

The triggers are fairly simple. For an example, look at table SPBPERS, the two triggers ST_SPBPERS_AS_LDI and ST_SPBPERS_AR_LDI.

The AS (after statement) trigger can be copied to your table virtually unchanged, just change it to your table name instead of spbpers.

The AR (after row) trigger is a little more complicated, though not much. Change the table name/field names throughout, and replace the tests with tests to match whatever can identify membership in the mailing list in your table. The only "action" in the trigger is CREATE; that basically just runs through the role definitions for that person to see which roles should be assigned and which should not, and then a record in GOBEQRC is created to sync that person over to Luminis.

If you post more details, I'd be glad to help.

Mon, 2008-09-08 19:37 — xhong

Thanks and will try soon

Due to other more urgent issues on portal front, I have not checked this site for a couple of day.
Thank you for your reply!!! I will try it, hopefully, in two days.
Xiaoling

Tue, 2008-09-09 19:36 — bwalker

Not all roles are transferred

Be aware that not all roles are transferred from Banner to Luminis. There is some place where you define the roles that are transferred(sorry can't remember where right now). This would be where the Student, Employee, Faculty, and all that are defined.
Bob