As a result, I had to edit SQL Views in order to add a new column and set its value using CASE - THEN - ELSE method . Works perfect!
Thank you all, issue solved! Koray. On Aug 31, 7:11 pm, "Grooms, Frederick W" <[email protected]> wrote: > Actually I have had to add color to a View form with a db View. In the db I > added an integer field I called DISPLAY_COLOR and put a Remedy selection > field against it. > > Depending on your database you can also add extra fields in a View of the db > Table so the table does not change. In oracle you can use the DECODE or CASE > type statements to do this. > > Fred > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of koray > Sent: Monday, August 31, 2009 10:00 AM > To: [email protected] > Subject: Re: Table Coloring W/O a Selection Field > > I am creating Views in SQL and View Forms in Admin, populating the > main form via these two. Therefore my circumstance is a bit more > complicated that I can not add any type of extra fields and implement > it that way. > > Otherwise, yes a hidden field would have saved my hours of research on > this issue :) > > Koray. > > On Aug 31, 5:38 pm, "Easter, David" <[email protected]> wrote: > > Is there a particular reason you do not wish to use a selection field to > > contain the enum for the color? Hopefully you know that you could make the > > field hidden and populated by workflow - it does not have to be a visible > > field or a value selected by an end user. > > > -David J. Easter > > Sr. Product Manager, Solution Strategy and Development > > BMC Software, Inc. > > > The opinions, statements, and/or suggested courses of action expressed in > > this E-mail do not necessarily reflect those of BMC Software, Inc. My > > voluntary participation in this forum is not intended to convey a role as a > > spokesperson, liaison or public relations representative for BMC Software, > > Inc. > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[email protected]] On Behalf Of Carey Matthew Black > > Sent: Monday, August 31, 2009 6:39 AM > > To: [email protected] > > Subject: Re: Table Coloring W/O a Selection Field > > > Alkan, > > > I noted that your post did not include what ARS version your using. > > That information may have been helpful to understand your full options. > > > So... You do not want to use the feature that is built into the system > > to do the task that you are trying to do. But you still want to do the > > task. > > > So.... How about any of the following alternatives? > > > If you only want this to work on the Mid-Tier you could: > > > Mid-Tier ONLY) Write some custom javascript that you trigger any time > > the form is refreshed (good luck trapping all of those cases, so there > > is more custom javascript needed for that) that would alter the CSS > > for the rows. > > > Mid-Tier ONLY2) You could use a column that is a display only, > > "HTML-ReadOnly" column and change the color of that cell, or put a > > colored image in the cell, in the row by using Active Links to loop > > over the table and set the correct HTML into the column. > > > But if you need this to work in the User Tool then you really need to > > use the feature as it is designed to work. ( Which should also work > > for the Mid-Tier client too. :) > > > I guess there are other approaches you could take... > > > Submit a UI enhancement request to BMC and wait (years?) to maybe see > > the second way to implement this feature show up in the product. > > > Oh.. how about this idea... This could work.... > > > You could create your own ARS client from the ground up. That would > > let you do all kinds of things in your UI. If it helps you would not > > be the first customer to do it. However it is no small task to achieve > > so that you can implement table field row colors based on something > > other than a selection field value from the table row. (Note: The UI > > enhancement request might be faster (and cheaper) than this option.) > > > Ok... I think I am totally out of ideas on this one... > > > Anyone else know of a better way to skin this cat? > > > HTH. > > > -- > > Carey Matthew Black > > BMC Remedy AR System Skilled Professional (RSP) > > ARS = Action Request System(Remedy) > > > Love, then teach > > Solution = People + Process + Tools > > Fast, Accurate, Cheap.... Pick two. > > > On Mon, Aug 31, 2009 at 8:06 AM, Alkan, Koray<[email protected]> wrote: > > > ** > > > Dear List, > > > > I am looking for a way to color table rows according to the values of > > > that table's specific row without using a dropdown list or a radio > > > field. > > > > Regards, > > > > Alkan, Koray > > > webhttp://www.alkankoray.net > > > mobile (0090) 555 204 9218 > > > e-mail [email protected] > > ___________________________________________________________________________ > ____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
