I recently started and ARDBC plugin to accomplish this. It will be
driven by a config file, which will using the following format:
<begin snippet>
USERNAME: Demo
PASSWORD:
ARSERVER: arsdev
# User count per license type
FORM User {
VendorTabke: User-LicenseCount
GROUPBY:109
AGGREGATE:1:COUNT(fieldid)
}
# Ticket count per CTI
FORM HPD:HelpDesk {
VendorTable: HPD:HelpDesk-TicketCountPerCTI
GROUPBY:200000003, 200000003, 200000003
AGGREGATE:1:COUNT(fieldid)
}
# Distinct submitter count per Region
FORM HPD:HelpDesk {
VendorTable: HPD:HelpDesk-TicketCountPerCTI
GROUPBY:200000012
AGGREGATE:2:COUNT(DISTINCT(fieldid))
}
<end snippet>
It's a refresher/crash course in C for me, so I can't say when it will
be complete. The idea is that you define the groupings and the
aggregates you want, which the plugin then presents in a vendor form.
When I publish this, you will be able to use the vendor form behind a
table field, but it will take some time before it's ready. Just
started it about a week ago.
Axton Grams
On 5/24/07, Rogerio <[EMAIL PROTECTED]> wrote:
What is the ARS version? What about the tree view table field (only for v.
7)??
Rogerio Bronzoni Aguiar
-----Mensagem original-----
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Em nome de L. J. Head
Enviada em: quinta-feira, 24 de maio de 2007 16:15
Para: arslist@ARSLIST.ORG
Assunto: Re: Select Distinct in Table Field?
Yea....that's why I stated 'without leaving remedy'...I know how to do the
DB View...I was looking for the ability without doing that
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rogerio
Sent: Thursday, May 24, 2007 12:49 PM
To: arslist@ARSLIST.ORG
Subject: RES: Select Distinct in Table Field?
You could build a SQL view and then a View Form on it. Then you could build
a table field over that view form.
HTH,
Rogerio Bronzoni Aguiar
[EMAIL PROTECTED]
-----Mensagem original-----
De: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Em nome de Kemes, Lisa Enviada em:
quinta-feira, 24 de maio de 2007 15:38
Para: arslist@ARSLIST.ORG
Assunto: Re: Select Distinct in Table Field?
The only way you can do this is by a SQL call within the Active Link or
Filter.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head
Sent: Thursday, May 24, 2007 2:33 PM
To: arslist@ARSLIST.ORG
Subject: Select Distinct in Table Field?
Is it possible to do a Distinct selection within a table field without
leaving remedy?
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
