Re: Need help with `! Filter in Help Desk Out of the Box 6.0

[Dan Caissie]

** Jase I have had the same problem with this issue, The filter or active link will run on modify but not on submit, but I did create an escalation that will do this until I have time to re-visit this issue. I wish I could help you more but I’m in the same boat and I just wanted to know your not going crazy! If I have time today I will run a log to see what’s going on with this, Also I had to do the same thing with Task so management could run reports on them to see what’s over due or not.   Dan Caissie Remedy Administrator / Developer United Natural Foods, Inc From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Friday, August 25, 2006 7:41 PM To: arslist@ARSLIST.ORG Subject: Need help with `! Filter in Help Desk Out of the Box 6.0   Hello fellow listers Help Desk 6.0 Out of the Box Arserver 6.3   How can I overcome th `! functionality of the out of the box SLA filters?   Desired result is a column on the Requester Console that will be 'SLA_Due_Date', so that when users log in to the requestor console they will see at a glance how much time they have until their ticket passes SLA.   With that being said, I added a new date/time field on SHR:Consolidated List called SLA_Date_Due so the filter would have a field to push the data into. I wrote a filter that executes on submit,  to do a push fields on SLA_Due_Date from SLA:Measurement to SHR:ConsolidatedList. This way the table field on the requester console that uses SHR:Consolidated List would display the SLA_Due_Date.   I  discovered that the out of the box SLA filters use the `! functionality and I can't get anything to work on submit, after submit, etc.   I have also tried adding a date/time field on SLA:Measurement and an active link with an execute on "after submit", qualification if "Request ID != $NULL$, then it does a set fields to my newly added date/time field. This link fails every time as if no request id exists, but I go to the record and there it is.   Then next, if date/time field != NULL,  filter does a push fields from SLA:Measurement to SHR:Consolidated. This doesn't work either because the first active link is failing.   I can't figure out how to do a push fields from the SLA:Measurement Form up to the SHR:ConsolidatedList form because I can't tell when the SLA:Measurement record is being created, I do see that it's using the `! functionality. Tried removing the `! from the name and that didn't affect anything either.   I can't get an active link or filter to work on this form on a submit or an after submit, it's like it doesn't do either one, but when I go to the form, there is the record . Only when I manually go in and touch the SLA:Measuement record and the object is set for modify, it works perfectly, set fields, then push fields, then new field pops up on the table field column everytime. Just as expected.   The bottom line, (sorry it took so long), I can't get an active link or filter to work on this form on a submit or an after submit. It will work on a modify if I dirty up the record. It's like it doesn't do either one, but when I go to the form, there is the record, so it had to be submitted at some point, right?   Somebody please tell me I am not crazy, I have spent the better part of two days banging my head on this one.     Jase Brandon Remedy Administration/Development Customer Support Systems Group Desk - (615) - 320-4494 Cell   - (334) - 318-5426 [EMAIL PROTECTED]   DaVita Inc. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___