Yeah I have taken a sql log and it is being queried (and no errors) T2067.C1,C1000000000,C7,C1000000164,C179,C230000009,C301626500,C1000000217,C1000000218,C1000000163,C3,C1000000161,C1000000150 FROM T2067 WHERE (((T2067.C230000009 = 'MAINCHANGE') AND ((T2067.C1000000427 = 'SGP000000000391') OR (T2067.C1000000427 = 'SGP000000000017') OR (T2067.C1000000427 = 'SGP000000000993') OR (T2067.C1000000427 = 'SGP000000000029') OR (T2067.C1000000427 = 'SGP000000000186') OR (T2067.C1000000427 = 'SGP000000000026') OR (T2067.C1000000427 = 'SGP000000000025')) AND (T2067.C1000000001 = 'Australian Taxation Office') AND ((T2067.C7 = 1) OR (T2067.C7 = 2) OR (T2067.C7 = 3) OR (T2067.C7 = 4) OR (T2067.C7 = 5) OR (T2067.C7 = 6) OR (T2067.C7 = 7) OR (T2067.C7 = 8) OR (T2067.C7 = 9))) OR ((T2067.C230000009 = 'MAINHELPDESK') AND ((T2067.C1000000079 = 'SGP000000000391') OR (T2067.C1000000079 = 'SGP000000000017') OR (T2067.C1000000079 = 'SGP000000000993') OR (T2067.C1000000079 = 'SGP000000000029') OR (T2067.C1000000079 = 'SGP000000000186') OR (T2067.C1000000079 = 'SGP000000000026') OR (T2067.C1000000079 = 'SGP000000000025')) AND (T2067.C1000000001 = ................
From: Robert Gajic Sent: Thursday, 13 June 2013 10:37 AM To: 'arslist@ARSLIST.ORG' Subject: Adding status reason column to overview console Hi Guys, I have read articles in developer communities etc on how to do this but am still having trouble. This will be long winded but hopefully I can get some help on how to add status reason to overview console (incident to start with). We are running with 7.6.03 (no patch) sql database on windows. 1. Ensure that status reason exists on template form ( I went with Help Desk Status_Reason with field ID of 1000000150 [cid:image002.png@01CE6821.309EB540] 2. Add if not there, a record on the ARDBC Fields form for the mapping [cid:image003.png@01CE6821.DE495380] 3. Added column for status reason (I added both consolidated status reason and status reason as I was experimenting with both and made sure permissions were given 4. Killed plugin and eventually restarted arservice but nothing turns up under status reason. Any thoughts would be very much appreciated! Robert Gajic ESMC Remedy Developer Lockheed Martin Australia Level 2, 53 Wentworth Avenue Kingston ACT 2604 Australia P.O. Box 6003 Kingston ACT 2604 Australia E-mail: robert.ga...@lmal.com.au<mailto:robert.ga...@lmal.com.au> [cid:image001.jpg@01CE6820.BFC676A0] ________________________________ This message is intended only for the use of the intended recipient(s) If you are not an intended recipient, you are hereby notified that any use, dissemination, disclosure or copying of this communication is strictly prohibited. If you have received this communication in error please destroy all copies of this message and its attachments and notify the sender immediately _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<inline: image001.jpg>>
<<inline: image002.png>>
<<inline: image003.png>>