Misi, Please pass along any info you can on the versions you used, what type of injections were made to the SELECT statements, and how to reproduce the issue. I need to make sure this doesn't cause problems before I upgrade our prod system to 7.0.1 patch 5.
Thanks, Chad Hall (501) 342-2650 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Friday, February 01, 2008 1:57 AM To: [email protected] Subject: Re: Setting values to the Advanced Search bar Hi Chad, I fully agree. I am suspecting that support dropped our issue because they did not understand it... The user of the '1005' in workflow was not the problem. The problem was that some strange code was injected into the SQL SELECT statement that had nothing to do with any workflow of ours. When the field was removed, things started to work again. I think this all happened in 2006. If you are interested, I can check my archives for the versions and exact problem. Best Regards - Misi, RRR AB, http://rrr.se > If BMC wants you to remove it, how else can you do things such as > checking the advanced search criteria when users execute a search? We > have workflow that requires users to use the advanced bar when they do a > search unless they specified something in our indexed field in the QBE > portion. It encourages them to make better searches. I'd like to keep > that functionality in 7.0. > > I've got a 7.0.1 patch 5 test server and my workflow still works. So > maybe it doesn't affect my system... or I haven't noticed the side > effects yet. > > Chad Hall > (501) 342-2650 > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky > Sent: Wednesday, January 30, 2008 4:36 AM > To: [email protected] > Subject: Re: Setting values to the Advanced Search bar > > Hi, > > Just add a display-only character-field with id 1005. > > I tried AR Admin 6.3, 7.0 and 7.1. They all had the Form -> Form Action > Fields menu. You have to open the form first. > > Because of the issues, I would advice against using it... I was kind of > dissapointed when BMC Support told us that it was not supported and > asked > us to remove it... > > Best Regards - Misi, RRR AB, http://rrr.se/sv/ > > >> So possibly it would work with my 6.3 but when I upgrade to 7.x it'll >> probably fail. I know that when we do searches now it does add other >> search >> variables to the string. You can see it when you go to the > Actions-->View >> Recent Searches. I remember Doug talking about adding other variables > to >> the >> string so the admins could control what is being searched. Maybe > that's >> why >> I never new about that field. >> >> But actually I don't have the option in my Admin tool to add as Frank >> suggested above. >> >> >> >> >> On 1/29/08, Misi Mladoniczky <[EMAIL PROTECTED]> wrote: >>> >>> Hi, >>> >>> I have had problems with field 1005, and support declared that it was >>> not >>> supported any more. This was in version 7.0. >>> >>> The problem was that the system added some strange things to the > select >>> statement when doing searches through the Windows Client. We had no >>> workflow that modified the content of the field, it was enough that > the >>> field existed... >>> >>> Best Regards - Misi, RRR AB, http://www.rrr.se >>> >>> Products from RRR Scandinavia: >>> * RRR|License - Not enough Remedy licenses? Save money by optimizing. >>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy >>> logs. >>> * RRR|Translator - Manage and automate your language translations. >>> Find these products, and many free tools and utilities, at >>> http://rrr.se. >>> >>> > Add field a field to your with field id 1005, Search Bar. You can > do >>> > this by opening a form, click tool bar Form and then Form Action >>> > fields. >>> > >>> > On Jan 28, 2008 4:30 PM, Arner, Todd <[EMAIL PROTECTED]> wrote: >>> >> ** >>> >> >>> >> Have you looked into using the defined searches function? I don't >>> >> remember >>> >> if it is supported on the 6.3 mid-tier but it is on 7.x. You set > the >>> >> defined search from the Admin Tool by going to the view properties >>> >> dialog of >>> >> the form. Then to access the search click on the Search menu from >>> the >>> >> mid-tier or action menu from the user tool. >>> >> >>> >> HTH, >>> >> Todd Arner >>> >> Great Lakes Educational Loan Services Inc. >>> >> >>> >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers >>> Are" >>> >> html___ >>> > >>> > >>> > ________________________________________________________________________ > _______ >>> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > Are" >>> > >>> > -- >>> > This message was scanned by ESVA and is believed to be clean. >>> > >>> >>> >>> > ________________________________________________________________________ > _______ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>> >> >> >> >> -- >> Thanks >> >> Steven Pataray >> Senior Analyst, Help Desk >> Bank of Hawaii >> 909 Dillingham Blvd, Honolulu, HI. 96817 >> 808 694-5078 >> >> > ________________________________________________________________________ > _______ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> >> -- >> This message was scanned by ESVA and is believed to be clean. >> >> > > > Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia: > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy > logs. > * RRR|Translator - Manage and automate your language translations. > Find these products, and many free tools and utilities, at > http://rrr.se. > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ************************************************************************ * > The information contained in this communication is confidential, is > intended only for the use of the recipient named above, and may be > legally privileged. > > If the reader of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or copying of this > communication is strictly prohibited. > > If you have received this communication in error, please resend this > communication to the sender and delete the original message or any copy > of it from your computer system. > > Thank you. > ************************************************************************ * > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
