select value, enumId FROM field_enum_values WHERE schemaId = '236' and fieldId = '7'
The actual number of values in this field have not changed since the field was modified after initial form creation. On Mon, May 16, 2011 at 5:35 PM, Joe Martin D'Souza <jdso...@shyle.net>wrote: > ** > No offence meant Susan.. Sometimes the best of us tend to overlook the > most simplest things.. That’s why they call our errors human errors :-) > > When you checked in your field_enum_data, what query did you use? I am > wondering if the old rows were not deleted in that table when the new rows > were inserted.. > > Joe > > *From:* Susan Palmer <suzanpal...@gmail.com> > *Sent:* Monday, May 16, 2011 6:21 PM > *Newsgroups:* public.remedy.arsystem.general > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Selection field enumId and value - where else can it be > hidden? > > ** > My apologies for not including our version info: > ARS 7.0.1P2 using admin tool v7.0.1P3 > Oracle 10g > Custom form > > Only one view (default) on the form. > Filter works when you eliminate that part of the qualification. > Not wrong form or wrong field (trying not to be insulted.... :) ) > Checked the alias and everything is appears as expected. > > Thanks so far ...... > > Susan > > > > On Mon, May 16, 2011 at 5:01 PM, Joe Martin D'Souza <jdso...@shyle.net>wrote: > >> ** >> >> You have checked in the right places and I am inclined to say that its >> almost impossible for the old values to be validated as valid, when saving a >> filter.. >> >> Since you say that you have even tried using the fields enumerated value >> while saving the filter, the only other possibility is you are checking it >> on the wrong form, or the wrong field or both.. >> >> Also, for a good measure, make sure that they don’t have the old value in >> the alias.. >> >> Cheers >> >> Joe >> >> >> *From:* Susan Palmer <suzanpal...@gmail.com> >> *Sent:* Monday, May 16, 2011 5:51 PM >> *Newsgroups:* public.remedy.arsystem.general >> *To:* arslist@ARSLIST.ORG >> *Subject:* Selection field enumId and value - where else can it be >> hidden? >> >> ** >> Hi everyone, >> >> I need some help. Originally on a form I had numerous values defined in >> selection field ID 7 (status). Several years later we changed the value >> and alias on 3 of those selections within that field. The actual >> 'numbering' did not change. When you look on the form everything is fine >> and has been for years. >> >> So now to the dilemma .... I have a new filter in which the Run If >> contains a qualification using one of those 3 'changed' values. >> >> It doesn't matter if I use the value or the enumId, after I save it, and >> reopen it, it gives me the OLD value. So really who cares, because I always >> thought everything really worked off the enumId in the background. >> >> BUT, the filter does not understand what it is supposed to do with it. No >> error on filter save. The filter runs when it's supposed to but fails >> qualification when that particular item does not match the run if. >> >> I've checked the form definition, the field definition, the >> field_enum_values data and it's all what it is supposed to be. Where is >> this old info hiding out? The filter is newly created. These particular >> field selection values have not been used in a run if before so never saw >> the issue. >> >> Thanks for your help in advance! >> >> Susan >> >> Susan Palmer >> ShopperTrak >> 200 W Monroe St >> 11th Floor >> Chicago, IL 60606 >> 312-529-5325 >> spal...@shoppertrak.com >> >> >> >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"