I am using this to "clear" the update flag on the vendor form data. Our eDir LDAP system writes new and updated records to my SQL Server table with a field named RunUpdate set to a value of 1. I use the vendor query to ONLY push records from vendor form to AR form if RunUpdate = 1; then I have the setting in the Response tab reset that value in the vendor table to 0. Future passes of the data exchange skip that record until another update from LDAP sets the RunUpdate flag to 1. It works like a champ, but I had to get some coaching from Doug in support to figure out how to use it. Query Tab - Data Key Query subtab: Vendor Query: RunUpdate = 1 Response tab: AR Resp Field: constant|"0" Vendor Resp Field: RunUpdate
Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/ _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, July 11, 2007 2:11 PM To: arslist@ARSLIST.ORG Subject: Response tab in the EIE:Datamapping form ** Listers, I was looking to find documentation on this, but cannot seem to find any references to this on either the eieadmin.pdf guide nor the sqlserver.pdf guide that is installed in the doc subdirectory of the EIE installation path. Does anyone know what exactly this mapping is used for? Does anyone know where to find documentations on it? Thanks Joe __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"