Thanks, that did work (force section into integer/numeric field). Found another solution too - go against a View - the DB value is the integer, but then all the date fields are integers too - :S
Regards, Andrew C. Goodall Software Engineer Development Services [email protected] jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Longwing, LJ CTR MDA/IC Sent: Thursday, July 12, 2012 2:55 PM To: [email protected] Subject: Re: retrieving enumerated (selection list) ID integer instead of value in filter action Andrew, I believe if you do as you suggested and set it to an int field you will get what you are looking for....but I also agree that a .ID type of thing would be beneficial :)....maybe submit an RFE...I would vote for it. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Goodall, Andrew C Sent: Thursday, July 12, 2012 1:01 PM To: [email protected] Subject: retrieving enumerated (selection list) ID integer instead of value in filter action ** My integration partner needs the urgency and impact value ID passed to them instead of the value/alias character string. How do I do this in a filter action? $urgency$ will always give me the value associated with ID=2000 (2-High), but I want it to return the ID value 2000. Do I have to set urgency to a temp integer field first, to get the ID? I would have thought it would have been something simple like $urgency$.ID Regards, Andrew C. Goodall Software Engineer Development Services [email protected] jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
