Hi Charlie, How to do the filter-log ? You mean turn on the filter log. I did not get it.
Thanks, Omega -----Original Message----- From: "Charlie Lotridge" <lotri...@mcs-sf.com> Sent: 9/12/14 5:53 AM To: "arslist@ARSLIST.ORG" <arslist@ARSLIST.ORG> Subject: Re: need some ideas from you how to show incidents records over 4hrinred color. ** Omega, run a filter log to make sure that the Get Entry filter is actually firing on each entry when you load (refresh) the table. I know that it'll fire when you access an individual entry on the source form (which uses the ARGetEntry API), but the table data retrieval probably uses the one of the APIs that retrieves multiple entries in a single call (e.g. ARGetListEntryWithFields, ARGetMultipleEntries, ARGetListEntryBlocks). I'm not sure if these will invoke the Get Entry filter on the individual entries (and don't have time to test it myself right now). Hope this helps. -charlie On Mon, Dec 8, 2014 at 1:43 PM, Omega LiPO <omegal...@gmail.com> wrote: ** I found it out this morning . And try it out. If I open the joined form, I see the color= can set to red or yellow. However, when I open the table field of such fields using display only form , the value did not show. Hmmm. I even set the filter order=0. I bet some ordering problem. Need more time to go testing tmr. Tks for your help. Regards, Omega From: Grooms, Frederick W Sent: 9/12/14 5:26 AM To: arslist@ARSLIST.ORG Subject: Re: need some ideas from you how to show incidents records over 4hrin red color. ** It is just a filter set to fire on Get Entry of your form. This filter fires each time a record is pulled from the database Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Omega LiPO Sent: Saturday, December 06, 2014 1:38 PM To: arslist@ARSLIST.ORG Subject: Re: need some ideas from you how to show incidents records over 4 hrin red color. ** Hi Fred, Cool. This is what in my original ideas but I don't know this "on get filter" any quick screen dump about this on Get filter" . Haha, I *only* know to use escalation to make the running-hr growth. Which needs to check the selection-color. Probably this is my first choice of testing on Monday morning. Thank you, Fred. Regards, Omega From: Grooms, Frederick W Sent: 6/12/14 1:30 AM To: arslist@ARSLIST.ORG Subject: Re: need some ideas from you how to show incidents records over 4 hrin red color. ** I was about to say You know … This would be so much easier if you could use Display Only fields from the “source” or underlying form in a table field. I just realized that you can select a Display Only selection field on the source form for the Color attributes of a table field. This should mean all you have to do is to add an “on Get” filter to the source form to set your color selection field. No Escalation needed. Create Display Only fields on your source form to hold running-hr and color selection Create one or more “on Get” filters on the source form to do your calculations NOTE: I would use $SERVERTIMESTAMP$ instead of $TIMESTAMP$ so you get the exact time when the filter fires Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Charlie Lotridge Sent: Friday, December 05, 2014 10:35 AM To: arslist@ARSLIST.ORG Subject: Re: need some ideas from you how to show incidents records over 4 hr in red color. ** Anyone who's read anything I've written over the past year (that I've been contributing here) knows I'm a big fan of using Remedy views over SQL views. And I've used this mechanism to implement exactly what you're looking for here, but without the table walk logic...much (much much) faster and more efficient since the database is doing all the work. In my case I wanted to implement something that showed a more typical aging ( < 30 days, 30-60 days, 60-90 days, > 90 days) but like you I wanted these differences to show as colored rows in the table. And while your requirement is to show aging measured in hours and mine is in days, the difference is irrelevant to the underlying solution. I'm not going to get into any detail here unless there's some interest that I do (it would take a bit of research & review to put it all together). I will mention, though, that the solution requires that the DB "know" the current time as a Unix epoch timestamp (and accurately, especially for your fine grained requirement). Of course all DB's know the current time, but accurately converting that to an epoch time (accurately!) can be a challenge. Since I use SQL Server and I'm a .NET guy, I was able to write a set of CLR stored procedures that manipulate timestamps at the DB level very quickly & efficiently, including one that returns the current time as an epoch timestamp. If you're also using SQL Server you'd be welcome to the source code for this (or even the compiled assembly if you prefer). But I don't have a comparable solution for any other DB platform. If you're interested in learning more let me know and perhaps it would be most considerate to the rest of the community to take it offline. -charlie On Thu, Dec 4, 2014 at 12:38 PM, LJ LongWing wrote: ** 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 wrote: ** I got some incident tickets. I managed to create an read-only form to show the un-closed [The entire original message is not included.] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"