select name from filter where filterid in ( select filterid from filter_push where fieldid in ( select fieldid from field where name = 'z1D Previous Operation')) and assignshort like '%HPD:WorkLog%' /
select name from filter where filterid in ( select filterid from filter_set where fieldid in ( select fieldid from field where name = 'z1D Previous Operation')) and filterid in (select filterid from filter_mapping where schemaid in ( select schemaid from arschema where name = 'HPD:WorkLog')) / ...check the same for active links. Could also be open window close mapping, which these will not catch. Axton Grams On 10/1/07, Gayford, Matthew C. <[EMAIL PROTECTED]> wrote: > ** > > > > Hello Listers, > > > > I recently got a call from our Help Desk that work info entries on incidents > were disappearing. After looking at the HPD:WorkLog form, we noticed that > some of the entries have had their status set to Delete. I turned on the > escalation and filter logs but haven't seen anything come across yet that is > setting this. > > > > I browsed the filters in the admin tool and found one called > HPD:WLG:SetStatus_500 that sets the Work Info status to Delete when 'z1D > Previous Operation' = "CREATE" (fires on submit to HPD:WorkLog). There is > also an else action to set the status to enabled. The question is, does > anyone know what workflow is setting z1D Previous Operation? So far my logs > haven't come up with anything, but the problem isn't occurring regularly. > > > > Thanks, > > > > -Matt > > > > ARS 7.0.01 ServiceDesk 7 MSSQL2005 Windows2003 > > Matthew C. Gayford > Technology Research & Development > Information Technology Systems Division > University of North Carolina Wilmington > (910) 962-7177 > > __20060125_______________________This posting was > submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
