I just took a peek at a 7.6.4 environment and it's already mapped there as well.
Look for multiple records in SHR:ARDBCFields where MAINHELPDESK/1000000150 is mapped and slim it down to the one provided out of the box. Then try adding in the field "ConsolidatedStatusReason" into your table and see if it's not populated for you already. If it's still not populating a server restart couldn't hurt and you definitely need to flush the MT cache. In the thick client clearing the arf/arv files is always good too. Sounds to me like you've done everything right except maybe running into an already-mapped field. On Wed, Jun 12, 2013 at 7:48 PM, Robert Gajic <robert.ga...@lmal.com.au>wrote: > ** > > 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**** > > **** > > ** ** > > **2. **Add if not there, a record on the ARDBC Fields form for the > mapping**** > > **** > > ** ** > > **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* > > [image: Description: uhyiuo]**** > > ** ** > > ------------------------------ > 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 > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
