too true! join forms is really not an option! the current solution is to have 1 form which contains the ticket number and some other relevant data as an entry in a List form, the User can click on a button to see the ticket, but this was designed way back on version 3 and has just been added on and on to, the same reason why there are 48 odd forms, everytime the users wanted something they designed a new form! consolidation was not a word mentioned!
I did not design the system, I just work on it. or should say try to work on it!
I will try and explain a bit further, they have tickets for example for customer problems, service requests, network problems, requests and so on, and each of these tickets can have child tickets or linked tickets.
As a user, I want to see all tickets assigned to me from any of the above systems, I want to see tickets for my group, all open tickets and so on and on.
So something to show all these tickets in a coherent form, and all updates to happen at the same time and be seen, because some of these tickets have a SLA of 10 minutes!!
I am currently thinking about having the List form and showing the entries in a table with chunking, the other issue is to have these entries updated as updates happen to the parent form, for example remove tickets that have been closed, show the correct status updates and so on.
thanks
shafqat
Rick Cook <[EMAIL PROTECTED]> wrote:
**Step away from the join form, please, sir. You are quite right - with that number of forms and records, the performance would be a nightmare. Your idea of something like a SHR:ConsolidatedList form might work, but it sounds like it would still have a significant workflow burden.Is the data in the 48 forms that similar that it would make sense to display it in one table? If so, why isn't it already in one table?How about using one table with an EXTERNAL command to specify the back-end form it references?Rick
** Hi List
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz
Sent: Tuesday, May 02, 2006 6:54 AM
To: arslist@ARSLIST.ORG
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___
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___
