Shafqat,
Instead of using Remedy Join Forms have you tried
creating a SQL View in your DBMS using UNION to bring all 48 forms
together? The performance might be much better than 48 Remedy Join
Forms. *It still may be too slow to be practical.
Another approach is to create a new form (ala
SHR:ConsolidatedList) and have Filters populate and maintain copies of the
fields you need to see on your CP.
HTH
Stephen
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz
Sent: Tuesday, May 02, 2006 9:54 AM
To: [email protected]
Subject: How do you show entries from 48 odd forms?
any bright ideas?
I need to have a CP and show entries from 48 forms? trying to have join forms is going to be extremely painful! each form can have hundreds of thousands entries, and the users want to see a consolidated list.
I could create a form and have just the main details of each ticket as a ticket on this form, any other way? and how to display something like a half million tickets intelligently?
ARS 5.2
Sybase 12.5.2
Mid-Tier 6.5
kind regards
shafqat ayaz
Shafqat Ayaz
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
