Re: How do you show entries from 48 odd forms?

Maybe you *should* redesign the system to have one form with a categorization of problems, rather than twenty different forms, one for each type of problem. Oz Shafqat Ayaz wrote: ** Carey I can understand your horror! but the way the app was designed, and it was done in version 3 to start w

Re: How do you show entries from 48 odd forms?

Shafqat, I would seriously hope that forking a process (or even a call to the plugin server) would have more overhead than a Push action would. I mean the ARS server has a standing connection to the DB. An API client would (likely) have to login to ARS then use the above connection anyway. :) -

Re: How do you show entries from 48 odd forms?

** CareyI can understand your horror! but the way the app was designed, and it was done in version 3 to start with,create a SQL table in the dbexecute a SQL statement that writes to this table a commandexecute a process that runs every 1 minute that then executes the command written in the SQL tabl

Re: How do you show entries from 48 odd forms?

Shafqat, I understand the problem at hand. But I have to question only one part of your explanation: " in the olden days since it was being done via SQL there could be a delay of upto 30 to 40 minutes before the new entry showed up(sometimes, but it had happened). " Given what I know of how

Re: How do you show entries from 48 odd forms?

In my opinion the only solution is to have filters on submit and modify on the forty forms and push things like ticket status, team, assigned tech, summary to a consolidated list form. This way the push is immediately done when the ticket is submitted. Of course you can create indexes on the appr

Re: How do you show entries from 48 odd forms?

** Hi CareyI agree with your post, but here is the situation, maybe it will make a little bit more sense.Say we have a company, which has a helpdesk, they are using a solution developed specifically for them, so it is not an Off the Shelf product.the way the original system was designed, rather tha

Re: How do you show entries from 48 odd forms?

, 2006 6:54 AMTo: arslist@ARSLIST.ORGSubject: How do you show entries from 48 odd forms? ** Hi Listany 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 wan

Re: How do you show entries from 48 odd forms?

Shafqat, I will only try to address this one part of your questions: "and how to display something like a half million tickets intelligently?" There are exactly zero known ways to do this in a tabular form. (Which is the best a table field in ARS can do for you.) There are ways to build summar

Re: How do you show entries from 48 odd forms?

@ARSLIST.ORGSubject: How do you show entries from 48 odd forms? ** Hi Listany 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

Re: How do you show entries from 48 odd forms?

SList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat AyazSent: Tuesday, May 02, 2006 6:54 AMTo: arslist@ARSLIST.ORGSubject: How do you show entries from 48 odd forms? ** Hi Listany bright ideas?I need to have a CP and show entries from 48 forms? trying to have join forms is going to be extr

How do you show entries from 48 odd forms?

** Hi Listany 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 tic