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
-----Original Message-----
From: Jose Huerta <jose.hue...@sm2baleares.es>
Sender: "Action Request System discussion list(ARSList)"
<arslist@ARSLIST.ORG>
Date: Thu, 26 Apr 2012 22:20:56
To: <arslist@ARSLIST.ORG>
Reply-To: arslist@ARSLIST.ORG
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 <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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
