Thanks LJ. I did discuss with my mantle and he also suggests the way as you did. Just that , I am not sure how to create this 'local field ' within the table-field. You mean, I need to create a local-hidden field under the original form, and hence , it becomes the local field in the table fields. However, my original form got over 200k tickets. So, walking the table might not work. Probably, I will try the db level suggestion from Charlie.
Once again, thank you all. // Omega -----Original Message----- From: "LJ LongWing" <[email protected]> Sent: 5/12/14 4:38 AM To: "[email protected]" <[email protected]> Subject: Re: need some ideas from you how to show incidents records over 4 hrin red color. ** Omega, First off, I would be careful with an auto refresh every 5 min's....as well intentioned as that is, it can come with a cost, especially if the user that has that console up is a Floating user... Second...instead of an escalation keeping track of the age...I would think about using a 'local' field in your table, and using an AL Guide loop to loop over the contents of the table on refresh that sets the column to value in question.... I only recommend that if you have 'limited' data in your table, because the walk takes some time.... I have a table I do that sort of thing with that I limit to 50 records per chunk and it takes less than a second or two to walk the table and populate the data... On Thu, Dec 4, 2014 at 1:16 PM, Hon Li <[email protected]> wrote: ** I got some incident tickets. I managed to create an read-only form to show the un-closed tickets, and set an auto-refresh says 300 seconds by active-link. now my users would like to highlight those tickets in yellow in color if 2-3 hr, and red in color if over 4-hr. So, I wonder if my following approach is correct or there is a better way. 1. create a calculation fields says running-hr = timestamp - create-date 2. create a selection-field [white, yellow, red] if running-hr >= 4 , and selection field is not-red, set selection field to red if running-hr > 2, <4 , and and selection-field is not yellow, set selection field to yellow else set selection to white ( or default as white) in the table-field, I can then set the color according to this selection field. To make this running-hr , "adding", I use the "escalation" running every 5-min to make the refresh frequency under the table. Question: do you think it will work ? have done the similar, and would it be a better approaches ? Please feel free to share me. many thanks from your help. Regards, Omega _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
