You don't even have to sql against the server ... you just right click on a form and Count and it tells you the number of records. You cannot get this done any easier and even if you buy ARUtilities it is a great investment for that feature and others.
Note: I'm not affiliated with the product have just been using it for many years! On Fri, Apr 27, 2012 at 8:53 AM, Eric Roys <[email protected]> wrote: > ** > > 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]> **** > > *Sender: *"Action Request System discussion list(ARSList)" < > [email protected]> **** > > *Date: *Thu, 26 Apr 2012 22:20:56 +0200**** > > *To: *<[email protected]>**** > > *ReplyTo: *[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, 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]> > wrote:**** > > ** **** > > That is great!**** > > ** ** > > On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn <[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]] *On Behalf Of *Jason Miller > *Sent:* Thursday, April 26, 2012 1:44 PM > *To:* [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]> > 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] > Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: > public.remedy.arsystem.general**** > > > To: [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 > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"**** > > **** > > _attend WWRUG12 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 ARSlist: "Where the Answers Are"_ **** > > ** ** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > ** ** > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG12 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. > _attend WWRUG12 www.wwrug.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"
