Roger,
Interesting requirement...
How about storing the name of the schema the user opens in db table and everytime a user opens a form up it stores that form name against his login name in a record if he has never opened that form before and sets a counter of the number of times he has opened it to 1.
If they open it again increase that counter by 1...
This could be done with a shared workflow, by excluding window opens if the open is via a DIALOG as that might not be a true representation of it being his favourite form...
Exclude the home page too from this...
Have the top 10 forms opened by this user by building a view form from a db view of this table...
Hope this helps..
Regards
Joe D'Souza
Remedy Developer / Consultant,
BearingPoint,
Time Warner Cable Project,
Virginia.
----- Original Message ----
From: "Nall, Roger" <[EMAIL PROTECTED]>
To: [email protected]
Sent: Thursday, July 20, 2006 4:28:04 PM
Subject: Form Favorites
**
From: "Nall, Roger" <[EMAIL PROTECTED]>
To: [email protected]
Sent: Thursday, July 20, 2006 4:28:04 PM
Subject: Form Favorites
**
ASR 6.3 patch 16
WIN2K
SQL2K
Does anyone know if there was a change to the way favorites are stored in the User tool in 6.0 or later?
Thanks,
Roger A. Nall
OSSNMS Sr. Remedy Administrator/Developer
T-Mobile USA
Desk: 973-644-3963
Cell: 973-652-6723
FAX: 973-490-3296
sf49fanv AIM IM
RogerNall Yahoo IM

