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"
