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 <omegal...@gmail.com> 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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"