Maybe a silly question but why don't you use an Active Link to do it??
Shafqat Ayaz
--- On Tue, 5/11/10, Raj <ravi6...@gmail.com> wrote:
From: Raj <ravi6...@gmail.com>
Subject: Re: {Remedy ARS} Re: COLCOUNT not working
To: arslist@ARSLIST.ORG
Date: Tuesday, May 11, 2010, 2:51 PM
Thanks again.
So, as per this query:
SELECT Count(Column FIeld) FROM HPD_Help_Desk WHERE Status = 0
In my case this table has only one column and the rows will keep on
increasing whenever there is a submit to that form.
Don't want to query , just need the number of rows from that table to
be set to the field.
So, my query should look like below: ???
SELECT Count(Case_ID) FROM Table1
Please let me know.
thanks,
Raj
On May 10, 10:53 am, ARSmarts Support <supp...@arsmarts.com> wrote:
> You can make use of the view created by ars. Here is an example:
> suppose you have a table name HPD:Help Desk, and count the New incidents in
> it. The sql statement would be
>
> SELECT Count(Case_ID) FROM HPD_Help_Desk WHERE Status = 0
>
> Status = 0 because it is the integer corresponding to the New value of the
> status field
>
> Best regards,
> ARSmarts support team
>
> ARSmarts, your most useful AR System companion.www.ARSmarts.com
>
> On 10 May 2010, at 18:41, Ravi wrote:
>
>
>
>
>
> > ** Thanks for the reply.
> > so,
> > DB ID of Table Name = Table1
> > DB ID of Column in the table = Column Field ( Only one column in this table
> > )
> > then my Set Field with SQL Source should look like :
> > SELECT COUNT(Column FIeld) FROM Table1 WHERE query ?
>
> > Please let me know.
>
> > Thanks.
>
> > On Mon, May 10, 2010 at 9:09 AM, ARSmarts Support <supp...@arsmarts.com>
> > wrote:
> > **
> > Hi,
>
> > You can make a filter with 2 set field actions:
> > - the 1st one is just setting a dummy field with the result of the query
> > you want to count the results
> > - the 2nd one uses the $LASTCOUNT$ keyword
>
> > or
> > you use a set field with SQL source, and write a query like SELECT
> > COUNT(Field1) FROM table_Name WHERE query
>
> > Best regards,
> > ARSmarts support team
>
> > ARSmarts, your most useful AR System companion.
> >www.ARSmarts.com
>
> > On 10 May 2010, at 17:41, Raj wrote:
>
> >> Hi All,
> >> Setting a field with COLCOUNT($COLUMN FIELD ID$) in a Set Fields
> >> action of a Filter on Submit. Seems is it not working. Always setting
> >> the field to a constant value of 15.
> >> Would like to set the field with the number of rows in that particular
> >> table. Is the any other way around to do this?
> >> How can it be done with the help of Direct SQL ?
>
> >> Please advise.
> >> Thanks,
> >> Ravi
>
> >> ___________________________________________________________________________
> >> ____
> >> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> >> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"
>
> > _attend WWRUG10www.wwrug.comARSlist: "Where the Answers Are"_
>
> > _attend WWRUG10www.wwrug.comARSlist: "Where the Answers Are"_
>
> ___________________________________________________________________________
> ____
> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
> attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"
>
> --
> You received this message because you are subscribed to the Google Groups
> "Remedy ARS" group.
> To post to this group, send email to arsl...@googlegroups.com.
> To unsubscribe from this group, send email to
> arslist+unsubscr...@googlegroups.com.
> For more options, visit this group
> athttp://groups.google.com/group/arslist?hl=en.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
