Weird Table field behavior on Midtier 7.1
List, We just upgraded our Windows 2003 midtier server from v6.3 to v7.1 patch 6 and now have users complaining about a weird behaviour. In a table field they want to select multiple entries using CTRL-mouse click and then hit a button to have the system perform operations on everything they selected. That all works fine, but the issue since the upgrade is that when they do the CTRL-mouse click, it always jumps the table back to the first item they selected. For example, they have a table field populated with 200 names and they need to select 10 people that completed a training class. They select the first one no problem and then scroll down looking for the next name to choose. They find it and select it using CTRL-mouse click and immediately they are taken back to the first name they selected which could be anywhere in the list. These subsequent selections ARE highlighted so the CTRL-mouse click is essentially working, but then they have to scroll down once again to find where they left off. Not only is it very annoying, especially if the subsequent names are close together, but it is also more time consuming when they have a large number of items to select. Has anyone else experienced this? Can it be fixed? I looked at the Table Field options and nothing jumped out at me, but then, it only happens on the Midtier and not the WUT. Also, it happens both against our production server (v6.3) and dev server (v7.1). I had Active Link logging turned on to make sure it wasn't some workflow that was firing and all I see in the log is the initial selection, and then nothing else until I choose the button to process the choices. It appears to be a feature that BMC introduced with Midtier 7 and now I need to know if there is a way around this feature. Thanks for any info! Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Urgent :: Diary Field Issue -- Please help
Wow! I just tried this on 7.5 patch 002 (HPUX 11, Oracle 10g) and it acted as you described. If you just put a space in a diary field and save it, the entire contents of the diary field are cleared out. I'm thinking you might want to call BMC and report it. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meenakshinathan Sent: Monday, August 31, 2009 6:39 AM To: arslist@ARSLIST.ORG Subject: Re: Urgent :: Diary Field Issue -- Please help List, Please let me know if anyone cannot understand my question? I am giving further more details.. Create a test from, add add a diary field into it. Open the form in aruser and create one request. open the same request and try to add a space and save the request. Now if you the diary field values, it does not contain any values. the empty space replaces the old values in diary field. I don;t know how to fix this, please help. Thanks, Meenakshinathan. On Aug 31, 5:02 pm, Meenakshinathan kmnat...@gmail.com wrote: Hi, I am in Remedy 7.5 patch 001 running on SuSE linux with oracle10g database. I need a solution urgently in my production system. I have a diary field which is using to store each user comments at various stages. If any one user is typed a space and modify the request the whole old diary information lost. Even in ,push field action modify request ,from a empty string character field to diary field also replaces the old information with null. Is there any properties is missing or do anyone can reproduce this error? Please let me know the solutions for this. i need to fix it as soon as possible. Thanks, Meenakshinathan __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Help with Oracle select statement
You should also put single quotes around $12257$ and remove the semi-colon at the end. Remedy will take care of that for you. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, September 16, 2008 10:04 AM To: arslist@ARSLIST.ORG Subject: Re: Help with Oracle select statement ** And when comparing null you use IS NOT NULL Or IS NULL Joe - Original Message From: Rick Cook [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, September 16, 2008 12:56:47 PM Subject: Re: Help with Oracle select statement ** OK, that makes sense, thanks. I think I'm close, but would like someone with more knowledge than I to take a look at my conversion and tell me why it's not working. Here's the original in a Query menu: (Selecting Tier 1 of a Category/Type/Item) ( 'Generic Categorization Tier 2' = $100745$) AND ( 'Generic Categorization Tier 1' = $100744$) AND ( 'Generic Categorization Tier 3' != $NULL$ ) AND ( 'Category Status' = Enabled) AND ( 'Category Type' = $102257$) I am attempting to add the Order by qualification and do it from a SQL menu. Here's what I have so far: SELECT Generic_Categorization_Tier_1 FROM CIS:HPD:Menu_Item_Ranking WHERE (Generic_Categorization_Tier_1 != NULL) AND (Category_Status = 'Enabled') AND (Category_Type = $102257$) ORDER BY Usage desc; I get an error saying ORA-00933: SQL command not properly ended. Rick On Tue, Sep 16, 2008 at 7:35 AM, Wallace, Kelvin [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: ** Rick, Try this: SELECT field1 FROM form ORDER BY field2 DESC; Kelvin From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Tuesday, September 16, 2008 10:16 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Help with Oracle select statement ** Am looking to get some specific syntax on a SQL call ARS 7 to Oracle 9 that would do the following: Select field1 from Form order by field2 (field2 is int field. I want the sort done highest value to lowest) Thanks! Rick __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
Re: Help with Oracle select statement
It must have been even further back in versions that you needed it. I am currently on Oracle 9i and I don't need to have my Order By field in the select statement. Mark From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, September 16, 2008 11:56 AM To: arslist@ARSLIST.ORG Subject: Re: Help with Oracle select statement ** You did need that before but with Oracle 10 G I have noticed it is no longer required to be in the select statement to order it by that.. Joe - Original Message From: Pargeter, Christie :CO IS [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, September 16, 2008 1:13:57 PM Subject: Re: Help with Oracle select statement ** my SQL for Dummies book says you need the order by field in the select part of the statement too. SELECT Generic_Categorization_Tier_1, Usage FROM CIS:HPD:Menu_Item_Ranking WHERE (Generic_Categorization_Tier_1 != NULL) AND (Category_Status = 'Enabled') AND (Category_Type = $102257$) ORDER BY Usage desc; -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Eaton, Mark (DCS) Sent: Tuesday, September 16, 2008 10:09 AM To: arslist@ARSLIST.ORG Subject: Re: Help with Oracle select statement ** You should also put single quotes around $12257$ and remove the semi-colon at the end. Remedy will take care of that for you. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, September 16, 2008 10:04 AM To: arslist@ARSLIST.ORG Subject: Re: Help with Oracle select statement ** And when comparing null you use IS NOT NULL Or IS NULL Joe - Original Message From: Rick Cook [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, September 16, 2008 12:56:47 PM Subject: Re: Help with Oracle select statement ** OK, that makes sense, thanks. I think I'm close, but would like someone with more knowledge than I to take a look at my conversion and tell me why it's not working. Here's the original in a Query menu: (Selecting Tier 1 of a Category/Type/Item) ( 'Generic Categorization Tier 2' = $100745$) AND ( 'Generic Categorization Tier 1' = $100744$) AND ( 'Generic Categorization Tier 3' != $NULL$ ) AND ( 'Category Status' = Enabled) AND ( 'Category Type' = $102257$) I am attempting to add the Order by qualification and do it from a SQL menu. Here's what I have so far: SELECT Generic_Categorization_Tier_1 FROM CIS:HPD:Menu_Item_Ranking WHERE (Generic_Categorization_Tier_1 != NULL) AND (Category_Status = 'Enabled') AND (Category_Type = $102257$) ORDER BY Usage desc; I get an error saying ORA-00933: SQL command not properly ended. Rick On Tue, Sep 16, 2008 at 7:35 AM, Wallace, Kelvin [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: ** Rick, Try this: SELECT field1 FROM form ORDER BY field2 DESC; Kelvin From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Tuesday, September 16, 2008 10:16 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Help with Oracle select statement ** Am looking to get some specific syntax on a SQL call ARS 7 to Oracle 9 that would do the following: Select field1 from Form order by field2 (field2 is int field. I want the sort done highest value to lowest) Thanks! Rick __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __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