Re: Esclation to update all of my people records
Hello , Filters on modify all will also trigger the underlying filter written on modify condition. If you have an very distinct search possible on those records ,and the fields you are trying to update are not display only then you can try updating the records using an simple sql procedure. directly run this against the db and this will not fire the filters on the people form if these are new fields you are trying to update. regards amit On Wed, May 22, 2013 at 6:46 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > LJ, You beat me to saying that > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj > Sent: Wednesday, May 22, 2013 8:13 AM > To: arslist@ARSLIST.ORG > Subject: Re: Esclation to update all of my people records > > ** > Howard, > Filters DO fire when doing a Mod-Allthere is no way to modify a record > that doesn't cause the filters to fire (other than special api > tricks)it's AL's that don't fire on Mod-All... > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Howard Richter > Sent: Tuesday, May 21, 2013 7:21 PM > To: arslist@ARSLIST.ORG > Subject: Esclation to update all of my people records > > ** > Good evening all, > > As I get older I forget the simple things. > > I created a filter to update a hidden field on the people form with a > combination of company/department/organization, for a license tracker I am > evaluating. > > Well I thought (again old age) that if I did a modify all from the user > tool the filter would fire. I forgot that filters don't fire when using a > modify all from the user tool. > > So I need to ask, what is the easiest escalation that I can create to > update all of my enabled user records? > > An old man thanks you, > > Howard > > Howard Richter > Red Hat Certified Technician > CompTIA Linux+ Certified > ITIL Foundation Certified > E-Mail = hrich...@richter-home.net > Linkedin profile http://www.linkedin.com/in/hbr4270 > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Issue in opening a display only form
Check on the workflow written on the load or opening of that particular display only form , Will suggest to first disable those. That will give you time for doing more analysis with number of fields and restructuring it for better performance. You can also trying to modify your workflow accordingly. Regards Amit On Fri, Jul 6, 2012 at 12:06 PM, Sreenivas wrote: > Hi, > > It is a customized application and we are bringing all the tasks(there > are quite big number of tasks) into one single form. Earlier each task > has one display-only form. Users requested to build in this way. > > Regards, > Sreenivas > > > On 6/29/12, Jose Huerta wrote: > > Can you explain us why do you need that quantity of fields? Just > curiosity. > > > > To show a lot of info? > > To use them as variables in code? > > ... > > > > Regards, > > Jose Huerta > > http://theremedyforit.com/ > > > > > > > > On Thu, Jun 28, 2012 at 8:15 PM, Misi Mladoniczky wrote: > > > >> Hi, > >> > >> I agree with Susan. Maybe your design is a little bit flawed, and you > can > >> do this in another way? > >> > >> In any event, I still think you should do a Save-As on your form, and > try > >> to open the new form. Did that work? > >> > >> The second thing would be to delete field. That should be quick enough > if > >> you multiselect with the lasso. > >> > >>Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP > 2011) > >> > >> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > >> * RRR|License - Not enough Remedy licenses? Save money by optimizing. > >> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy > logs. > >> Find these products, and many free tools and utilities, at > http://rrr.se. > >> > >> > I think you've probably generated some curiosity with this issue. I > >> have > >> > data forms with maybe 600 fields and other developers often express > >> > negative opinions about that. I understand yours is a display form, > >> > but > >> > what are these fields for? That is alot of fields! > >> > > >> > Susan > >> > > >> > On Thu, Jun 28, 2012 at 8:33 AM, Sreenivas > wrote: > >> > > >> >> Thanks Misi for quick response. > >> >> > >> >> We are trying by deleting recently added fields but there are 500 > >> >> fields added in this week. Till now it is not yet getting opened in > >> >> user tool. > >> >> > >> >> Any other ideas please > >> >> > >> >> Is it really an issue if we have high number fields? We need to add > >> >> more fields on this form. it may cross 5k fields also. > >> >> > >> >> Regars, > >> >> Sreenivas > >> >> > >> >> > >> >> > >> >> On 6/28/12, Misi Mladoniczky wrote: > >> >> > Hi, > >> >> > > >> >> > Make a copy of the form (save as) and try that one. > >> >> > > >> >> > If it does not work, remove half the fields and try that. > >> >> > > >> >> > That is a rather high number of fields... > >> >> > > >> >> > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList > MVP > >> >> 2011) > >> >> > > >> >> > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > >> >> > * RRR|License - Not enough Remedy licenses? Save money by > >> >> > optimizing. > >> >> > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy > >> >> logs. > >> >> > Find these products, and many free tools and utilities, at > >> >> http://rrr.se > >> >> . > >> >> > > >> >> >> Dear All, > >> >> >> > >> >> >> We have 3844 fields on a display-only form. Does it cause any > issue > >> >> >> while opening a form in user tool. It is working fine in thin > >> >> >> client > >> >> >> however when we open the same form in thick client, window gets > >> >> >> freezed. Any idea why it is not working in user tool. > >> >> >> > >> >> >> Environment: > >> >> >> ARS Server - 7.0.1 > >> >> >> User Tool- 7.0.1 > >> >> >> Oracle 10g > >> >> >> > >> >> >> > >> >> >> Regards, > >> >> >> Sreenivas > >> >> >> > >> >> >> > >> >> > >> > ___ > >> >> >> 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" > >> >> > > >> >> > >> >> > >> >> > >> > ___ > >> >> 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" > >> > > >> > >> > >> > _
Remedy Web Mid tier issue
Hello All, We are facing issues with Mid tier where the apache process gets hung on one of the web servers.Restarting the web server with apache and tomcat resolves the issue. But the prefetch running on the web boxes takes a lot longer time than usual. The catalina.out logs contains too many broken pipe errors. We are on ARS 7.1 and ITSM 7 with oracle 10. Please let me know if any body has faced this issue. Snippets from the logs (Catalina.out and midtier logs) - Caused by: ERROR (9093): User is currently connected from another machine; at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) ERROR (623): Authentication failed; at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) - Error releasing the previous user Gneefs ERROR (623): Authentication failed; at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) -- Nov 9, 2011 3:03:53 PM - WARNING (com.remedy.log.SESSION) : (Thread 133) com.remedy.arsys.log.Log log Error loading preference from server http://Load balancer name for the user ARERR [91] RPC call failed : Broken pipe Nov 9, 2011 3:05:16 PM - WARNING (com.remedy.log.SESSION) : (Thread 249) com.remedy.arsys.log.Log log Error loading preference from server Load balancer name for the user ARERR [90] Cannot establish a network connection to the AR System server : Invalid option or socket reset by remote peer http://Load balancer server name --- Thanks and Regards Amit ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
change management slowness
Hello All, We are facing slowness issues with change management ITSM 7. I ran all the logs and found the only in the api logs particularly the calls in regards to GMSF = ARGetMultipleFields call is taking much of time. SQL logs are clean. Even in any logs there is no error registered only slowness is the issue. Any ideas is welcome as i am out of those now. However i am having escalation, approval and assignment engine running on an single box.Will it cause any issues. Regards Amit ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Architecture Question
Hello, We have 9 web , 3 app and 2 reporting server and concurrent user base of 900 people ... regards amit On Mon, Apr 25, 2011 at 11:10 PM, patchsk wrote: > If I understand correctly you have 3 webservers, 2 app servers, 1 > reporting server. > This is pretty common architecture so should not cause any network > clog or anything, assuming your userbase is not very excessive. > As for the performance tuning there are several things to do, go > through the configuration guide. > At a highlevel, > make sure your db and app are with in the same VLAN. > router is set to fullduplex negotiation. > Set the db cursor sharing to FORCE > store clobs in a row > > On Apr 25, 8:44 am, "remedy.help" wrote: > > Hello All. > > > > We have the following setup > > > > ITSM 7.1/solaris/Oracle 10 g > > > > We have multiple web server 3 app and 2 reporting server. > > > > We have common DB and app servers are in server group. i have a > > query "will such an architecture or set up clog on network when multiple > > read/write requests are generated". > > > > What will be optimum setup to run a show without slowness. Also what > > performance tuning we can do on DB or application. > > > > Any inputs are welcome with reasons, > > > > Regards > > Amit > > > > > ___ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > 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"
Architecture Question
Hello All. We have the following setup ITSM 7.1/solaris/Oracle 10 g We have multiple web server 3 app and 2 reporting server. We have common DB and app servers are in server group. i have a query "will such an architecture or set up clog on network when multiple read/write requests are generated". What will be optimum setup to run a show without slowness. Also what performance tuning we can do on DB or application. Any inputs are welcome with reasons, Regards Amit ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
reporting error
Hello List, We are facing issues with crystal reports. The reports does not come up and the error thrown is ARerr 9386 over web. however AR reports are working fine though, Crystal is configured on windows box with ARS 7 on solaris 10. Db is oracle 10. Any help is appreciated Regards Amit ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Advice Needed
Hello All, I have a question in replicating DB backups to make new system. For e.g. if we have a remedy ITSM box (test1)ready with all the application and data build and configured(Foundation). Can i take a full database backup and restore it to a new oracle installation and use it as a test 2 box.Make changes in ar.conf, for server name etc and then start the remedy service. Or what is the fastest and easiest way to create three remedy boxes as test1,test2 and test3. I just want to save time in installing and uploading data into systems. Env :OS : Windows DB : Oracle 10g ARServer: ITSM 7.6.03 Regards ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: SQL help needed
Thanks Conny, This works great as a query regards On Wed, Feb 17, 2010 at 1:46 AM, Conny Martin wrote: > ** > if you turn on sql-logging and search for users belong to administrator > group you will see a statement like this. > > SELECT * FROM ( SELECT > T31.C1,C101,C536870913,C8,C536870912,C54000,C54002 FROM T31 WHERE > ((T31.C104 > LIKE '1;%') OR (T31.C104 LIKE '% 1;%') OR (T31.C104 LIKE '%;1;%')) ORDER > BY 1 ASC ) > > This makes sense because in earlier versions of arsystem the groupids were > separeted by ; and now it's only separated by ; > > Kind Regards Conny > > -- > *Von:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *Im Auftrag von *Joe D'Souza > *Gesendet:* Dienstag, 16. Februar 2010 23:27 > *An:* arslist@ARSLIST.ORG > *Betreff:* Re: SQL help needed > > ** > The second statement should be > > select count(*) from t9 where c104 like '1; %' or c104 like '% 1; %'; > > However I would rather use the view name of the user form which is user_x > instead of t9 because if you are writing code that needs to be migrated > across servers, writing SQL statements on the T tables may not be the best > idea unless in your environment you are absolutely sure that you have the > whole table structures migrated across systems maintaining the identical T > numbers for those tables across environments.. > > So I would rather prefer the statement > > select count(*) from user_x where group_list like '1; %' or group_list like > '% 1; %'; > > This statement will be good for all environments irrespective of how > careful you are to ensure ideal case database migrations between different > environments... > > As far as parsing the group ID's to real group names, if you absolutely > have to do it using direct SQL queries why not try writing a stored > procedure to do it? It may be a lot easier.. > > Joe > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org]*on Behalf Of *remedy.help > *Sent:* Tuesday, February 16, 2010 5:09 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: SQL help needed > > ** > What i need --> > > I need to pull out the group names from group list field(c104). Since it > contains the group id and not the group names i need to convert it back to > group names; > > Also can we do a select statement for group list field where we say > > select count(*) from t9 where c104 like '1'; > > I am on oracle DB and the list i have checked for every other string > habits; > > regards > > > > On Tue, Feb 16, 2010 at 4:00 PM, Joe D'Souza wrote: > >> ** >> Have you tried retrieving the same using a simple select statement using a >> like clause? I do not see a distinct advantage of using a cursor to retrieve >> what you are trying to. >> >> Joe >> >> -Original Message- >> *From:* Action Request System discussion list(ARSList) [mailto: >> arsl...@arslist.org]*on Behalf Of *remedy.help >> *Sent:* Tuesday, February 16, 2010 4:42 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: SQL help needed >> >> ** >> the error points to the Fetch statement Fetch C1 into froup_id,group_name >> It will be great if somebody has done sql manipulations on the C104 filed >> of the t9(User Form) >> >> On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza wrote: >> >>> ** >>> What is the error that you are getting? >>> >>> Joe >>> >>> -Original Message- >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arsl...@arslist.org]*on Behalf Of *amit dw >>> *Sent:* Tuesday, February 16, 2010 4:20 PM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* SQL help needed >>> >>> ** >>> Hello All, >>> >>> >>> Below is the problem and way I was trying to handle it >>> >>> >>> >>> C_list contains comma separated values of group Id’s. this list contains >>> all the group id’s associated to a particular login name. >>> >>> >>> >>> C_list= (1,15005,85,83,84,805) >>> >>> >>> >>> This variable will be holding up dynamically value in numbers. >>> >>> >>> >>> For group id numbers in simple sql statement we can get the result >>> corresponding name using the below query, >>> >>> >>> >
Re: SQL help needed
Appreciate the Pointer..Will work on that and update with the results; On Tue, Feb 16, 2010 at 4:57 PM, Joe D'Souza wrote: > ** > The reason that '1%' will throw a lot of results some of which are not > relevant is because by that you are indicating that all records that have > C104 end with 1 to be returned.. > > Instead if you use C104 like '1;%' or C104 like '% 1;%' (notice the space > before 1), you will limit the results to wherever there is a 1; only.. > > I do not have a model code for your other example, but you could check the > SQL that Remedy uses, to convert the string from ID's to name when you pull > up a user record on the user form.. SQL logging will reveal that. They do > not use a stored procedure, but you could use the same SQL logic that is > used to write your own.. > > Joe > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org]*on Behalf Of *remedy.help > *Sent:* Tuesday, February 16, 2010 5:39 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: SQL help needed > > ** > Joe, > > Thanks for the response but the query on C104 doesnt catches it and if we > give like '1%' it throws up lot of results. > > I was trying to write stored procedure for getting the names, but there > also i am facing issues because of the variable containing mutliple values > deliminated by ';' > > it will be great if you have something written on it and i can use it as > model code > > ... > > On Tue, Feb 16, 2010 at 4:27 PM, Joe D'Souza wrote: > >> ** >> The second statement should be >> >> select count(*) from t9 where c104 like '1; %' or c104 like '% 1; %'; >> >> However I would rather use the view name of the user form which is user_x >> instead of t9 because if you are writing code that needs to be migrated >> across servers, writing SQL statements on the T tables may not be the best >> idea unless in your environment you are absolutely sure that you have the >> whole table structures migrated across systems maintaining the identical T >> numbers for those tables across environments.. >> >> So I would rather prefer the statement >> >> select count(*) from user_x where group_list like '1; %' or group_list >> like '% 1; %'; >> >> This statement will be good for all environments irrespective of how >> careful you are to ensure ideal case database migrations between different >> environments... >> >> As far as parsing the group ID's to real group names, if you absolutely >> have to do it using direct SQL queries why not try writing a stored >> procedure to do it? It may be a lot easier.. >> >> Joe >> >> -Original Message- >> *From:* Action Request System discussion list(ARSList) [mailto: >> arsl...@arslist.org]*on Behalf Of *remedy.help >> *Sent:* Tuesday, February 16, 2010 5:09 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: SQL help needed >> >> ** >> What i need --> >> >> I need to pull out the group names from group list field(c104). Since it >> contains the group id and not the group names i need to convert it back to >> group names; >> >> Also can we do a select statement for group list field where we say >> >> select count(*) from t9 where c104 like '1'; >> >> I am on oracle DB and the list i have checked for every other string >> habits; >> >> regards >> >> >> >> On Tue, Feb 16, 2010 at 4:00 PM, Joe D'Souza wrote: >> >>> ** >>> Have you tried retrieving the same using a simple select statement using >>> a like clause? I do not see a distinct advantage of using a cursor to >>> retrieve what you are trying to. >>> >>> Joe >>> >>> -Original Message- >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arsl...@arslist.org]*on Behalf Of *remedy.help >>> *Sent:* Tuesday, February 16, 2010 4:42 PM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Re: SQL help needed >>> >>> ** >>> the error points to the Fetch statement Fetch C1 into froup_id,group_name >>> It will be great if somebody has done sql manipulations on the C104 filed >>> of the t9(User Form) >>> >>> On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza wrote: >>> >>>> ** >>>> What is the error that you are getting? >>>> >>>> Joe >>>> >
Re: SQL help needed
Joe, Thanks for the response but the query on C104 doesnt catches it and if we give like '1%' it throws up lot of results. I was trying to write stored procedure for getting the names, but there also i am facing issues because of the variable containing mutliple values deliminated by ';' it will be great if you have something written on it and i can use it as model code ... On Tue, Feb 16, 2010 at 4:27 PM, Joe D'Souza wrote: > ** > The second statement should be > > select count(*) from t9 where c104 like '1; %' or c104 like '% 1; %'; > > However I would rather use the view name of the user form which is user_x > instead of t9 because if you are writing code that needs to be migrated > across servers, writing SQL statements on the T tables may not be the best > idea unless in your environment you are absolutely sure that you have the > whole table structures migrated across systems maintaining the identical T > numbers for those tables across environments.. > > So I would rather prefer the statement > > select count(*) from user_x where group_list like '1; %' or group_list like > '% 1; %'; > > This statement will be good for all environments irrespective of how > careful you are to ensure ideal case database migrations between different > environments... > > As far as parsing the group ID's to real group names, if you absolutely > have to do it using direct SQL queries why not try writing a stored > procedure to do it? It may be a lot easier.. > > Joe > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org]*on Behalf Of *remedy.help > *Sent:* Tuesday, February 16, 2010 5:09 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: SQL help needed > > ** > What i need --> > > I need to pull out the group names from group list field(c104). Since it > contains the group id and not the group names i need to convert it back to > group names; > > Also can we do a select statement for group list field where we say > > select count(*) from t9 where c104 like '1'; > > I am on oracle DB and the list i have checked for every other string > habits; > > regards > > > > On Tue, Feb 16, 2010 at 4:00 PM, Joe D'Souza wrote: > >> ** >> Have you tried retrieving the same using a simple select statement using a >> like clause? I do not see a distinct advantage of using a cursor to retrieve >> what you are trying to. >> >> Joe >> >> -Original Message- >> *From:* Action Request System discussion list(ARSList) [mailto: >> arsl...@arslist.org]*on Behalf Of *remedy.help >> *Sent:* Tuesday, February 16, 2010 4:42 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: SQL help needed >> >> ** >> the error points to the Fetch statement Fetch C1 into froup_id,group_name >> It will be great if somebody has done sql manipulations on the C104 filed >> of the t9(User Form) >> >> On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza wrote: >> >>> ** >>> What is the error that you are getting? >>> >>> Joe >>> >>> -Original Message- >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> arsl...@arslist.org]*on Behalf Of *amit dw >>> *Sent:* Tuesday, February 16, 2010 4:20 PM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* SQL help needed >>> >>> ** >>> Hello All, >>> >>> >>> Below is the problem and way I was trying to handle it >>> >>> >>> >>> C_list contains comma separated values of group Id’s. this list contains >>> all the group id’s associated to a particular login name. >>> >>> >>> >>> C_list= (1,15005,85,83,84,805) >>> >>> >>> >>> This variable will be holding up dynamically value in numbers. >>> >>> >>> >>> For group id numbers in simple sql statement we can get the result >>> corresponding name using the below query, >>> >>> >>> >>> Select c105,c106 from t10 where c106 in (1, 101,102,104). >>> >>> >>> >>> Same query when I tried transforming in a cursor it throws up a >>> compilation error. The error points out to a fetch statement where we try >>> and fetch the data from the cursor for one particular group id. >>> >>> >>> >>> Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); >>> >>> Begin >>> >>> Open c1; >>> >>> Loop >>> >>> Fetch C1 into g_num,g_name; >>> >>> dbms_output.put_line(g_name); >>> >>> EXIT WHEN C1%NOTFOUND; >>> >>> END LOOP; >>> >>> Close c1; >>> >>> End; >>> >>> >>> >>> Hope it explains the problem I am facing. >>> >>> Any suggestions/Comments or previously implemented code will be helpful >>> for me. >>> >>> _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: SQL help needed
What i need --> I need to pull out the group names from group list field(c104). Since it contains the group id and not the group names i need to convert it back to group names; Also can we do a select statement for group list field where we say select count(*) from t9 where c104 like '1'; I am on oracle DB and the list i have checked for every other string habits; regards On Tue, Feb 16, 2010 at 4:00 PM, Joe D'Souza wrote: > ** > Have you tried retrieving the same using a simple select statement using a > like clause? I do not see a distinct advantage of using a cursor to retrieve > what you are trying to. > > Joe > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org]*on Behalf Of *remedy.help > *Sent:* Tuesday, February 16, 2010 4:42 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: SQL help needed > > ** > the error points to the Fetch statement Fetch C1 into froup_id,group_name > It will be great if somebody has done sql manipulations on the C104 filed > of the t9(User Form) > > On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza wrote: > >> ** >> What is the error that you are getting? >> >> Joe >> >> -Original Message- >> *From:* Action Request System discussion list(ARSList) [mailto: >> arsl...@arslist.org]*on Behalf Of *amit dw >> *Sent:* Tuesday, February 16, 2010 4:20 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* SQL help needed >> >> ** >> Hello All, >> >> >> Below is the problem and way I was trying to handle it >> >> >> >> C_list contains comma separated values of group Id’s. this list contains >> all the group id’s associated to a particular login name. >> >> >> >> C_list= (1,15005,85,83,84,805) >> >> >> >> This variable will be holding up dynamically value in numbers. >> >> >> >> For group id numbers in simple sql statement we can get the result >> corresponding name using the below query, >> >> >> >> Select c105,c106 from t10 where c106 in (1, 101,102,104). >> >> >> >> Same query when I tried transforming in a cursor it throws up a >> compilation error. The error points out to a fetch statement where we try >> and fetch the data from the cursor for one particular group id. >> >> >> >> Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); >> >> Begin >> >> Open c1; >> >> Loop >> >> Fetch C1 into g_num,g_name; >> >> dbms_output.put_line(g_name); >> >> EXIT WHEN C1%NOTFOUND; >> >> END LOOP; >> >> Close c1; >> >> End; >> >> >> >> Hope it explains the problem I am facing. >> >> Any suggestions/Comments or previously implemented code will be helpful >> for me. >> >> _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: SQL help needed
the error points to the Fetch statement Fetch C1 into froup_id,group_name It will be great if somebody has done sql manipulations on the C104 filed of the t9(User Form) On Tue, Feb 16, 2010 at 3:37 PM, Joe D'Souza wrote: > ** > What is the error that you are getting? > > Joe > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org]*on Behalf Of *amit dw > *Sent:* Tuesday, February 16, 2010 4:20 PM > *To:* arslist@ARSLIST.ORG > *Subject:* SQL help needed > > ** > Hello All, > > > Below is the problem and way I was trying to handle it > > > > C_list contains comma separated values of group Id’s. this list contains > all the group id’s associated to a particular login name. > > > > C_list= (1,15005,85,83,84,805) > > > > This variable will be holding up dynamically value in numbers. > > > > For group id numbers in simple sql statement we can get the result > corresponding name using the below query, > > > > Select c105,c106 from t10 where c106 in (1, 101,102,104). > > > > Same query when I tried transforming in a cursor it throws up a compilation > error. The error points out to a fetch statement where we try and fetch the > data from the cursor for one particular group id. > > > > Declare cursor c1 as select c105,c106 from t10 where c106 in(c_list); > > Begin > > Open c1; > > Loop > > Fetch C1 into g_num,g_name; > > dbms_output.put_line(g_name); > > EXIT WHEN C1%NOTFOUND; > > END LOOP; > > Close c1; > > End; > > > > Hope it explains the problem I am facing. > > Any suggestions/Comments or previously implemented code will be helpful for > me. > > _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"
