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 <jason.mil...@gmail.com> wrote: > ** > That is great! > > > On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn <shawn.pier...@sug.com>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: >> arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller >> *Sent:* Thursday, April 26, 2012 1:44 PM >> *To:* arslist@ARSLIST.ORG >> *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 <jdso...@shyle.net> >> 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: remedyarl...@gmail.com >> Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: >> public.remedy.arsystem.general**** >> >> >> To: arslist@ARSLIST.ORG >> 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"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"