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 at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > > > > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _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"
