You might just want to download ARUtilities application (google it). It’s free for a time (until trial expires) and provides a means to do sql against the server as you would by building a form/logic as you indicated. It does other things too.
Note: I’m not affiliated with the product. It just seems you need a solution that doesn’t require effort or introducing code on the system itself, that will open the proverbial can of worms. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, April 27, 2012 5:39 AM To: [email protected] Subject: Re: Count of records ** Thank you all for your ideas... Looks like I have to build a new form with a drop down field with arschema as menu value. On selection of each form, on demand query runs and real time count is provided. Sent on my BlackBerry® from Vodafone ________________________________ From: Jose Huerta <[email protected]<mailto:[email protected]>> Sender: "Action Request System discussion list(ARSList)" <[email protected]<mailto:[email protected]>> Date: Thu, 26 Apr 2012 22:20:56 +0200 To: <[email protected]<mailto:[email protected]>> ReplyTo: [email protected]<mailto:[email protected]> Subject: Re: Count of records ** I know you can't customize nor access the DB. I see no solution to your case. But I can provide you some solutions, customizing or accessing the database. All of this is for Oracle. 1.- Run an SQL sentence: SELECT A.SCHEMAID, A.NAME<http://A.NAME>, A.NEXTID, T.NUM_ROWS FROM ARSCHEMA A JOIN user_tables T ON ( ('T' ||TRIM(TO_CHAR(A.SCHEMAID))) = T.TABLE_NAME) Provides you the next ID and number of requests at each regular form. 2.- Create a view using the previous SQL and map it to a View Form. 3.- Create a view form mapping the user_tables table. Then create a join view between this form and the AR System metadata:arschema form, with the join qualification like the provided one. Regards, Jose Huerta http://theremedyforit.com/ On Thu, Apr 26, 2012 at 21:09, Jason Miller <[email protected]<mailto:[email protected]>> wrote: ** That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn <[email protected]<mailto:[email protected]>> wrote: ** In order to help developers like myself get better at filtering data, my son is named Robert’); DROP TABLE Students;-- Pierson. http://xkcd.com/327/ Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Jason Miller Sent: Thursday, April 26, 2012 1:44 PM To: [email protected]<mailto:[email protected]> Subject: OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza <[email protected]<mailto:[email protected]>> wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement ==> select count(*) from <view name> Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -----Original Message----- From: [email protected]<mailto:[email protected]> Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: [email protected]<mailto:[email protected]> Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ Private and confidential as detailed here<http://www.sug.com/disclaimers/default.htm#Mail>. If you cannot access hyperlink, please e-mail sender. _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ CONFIDENTIALITY NOTICE: This email communication is intended only for the personal and confidential use of the recipient(s) designated above and may contain information which is subject to Federal and/or State privacy laws. In the event that you are not the intended recipient or the agent of the intended recipient, you are hereby notified that any review, disclosure, or use of the information contained herein is strictly prohibited. Do not copy or use the information contained within this communication, or allow it to be read, copied or utilized in any manner by any other person(s). If you have received this communication in error, please notify the sender immediately, either by response e-mail or by phone, and permanently delete the original e-mail, any attachment(s), and copies. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
