I am off to bed so I'll be a little sparse on the detail in this reply... The DB view U__HPD_Help_Desk is an out of the box view, I only added a column to it. That view and one for each of the other forms Change, Problem, Work Order, Task, etc. also have similar out of the box DB views. When all is said and done the views need the same number of columns so they all need to be updated even if its only value is a hard coded space ( ' ' ). If you look at the screenshot in my previous reply there are a number of columns that will only ever return ' ' but on one of the other forms that column will have a value so every other form (DB view) needs a placeholder.
Once you have added your calculation column (using *getdate()* instead of Last Modified in my original example) to the HPD view and the dummy columns to every other view used in the Overview UNION view, then you simply add the new column to the view form referencing the DB UNION view. There is no need to change the DB UNION view since it does a *SELECT ** . From what I have seen it can be tricky to get your View Form to see that there is a new column. Restarting AR Server should take care of that. I am trying to remember how I did this in production without restarting AR Server.... Don't remember if it was Dev Studio cache and restarting Dev Studio took care of it or maybe I added a new field to the view form which made it re-read the UNION view columns?.?.?. There is a way, you just need to make the system see there is a new column. Maybe I simply did an ALTER VIEW on the UNION DB view and the system noticed? (that wasn't as sparse as I thought it would be) Good night Y'all Jason On Wed, Feb 7, 2018 at 1:41 AM, Abhishek2019 <abhi.masc...@gmail.com> wrote: > Thanks a ton Jason for your superb response. > > I am trying to summarize it in detail:- > > You created a new DB view & added the custom field for the aging > calculation > in it. > After that how to retrieve it in overview console table?? > > Also even after adding the custom field in the overview console table , > how > are we going to retrieve the real time aging calculation for each incident > in the overview console table...?? > > Early response will be highly appreciated. > > Cheers, > AA > > > > > > -- > Sent from: http://ars-action-request-system.1.n7.nabble.com/ > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist >
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
