It depends ... What is your table field's qualification statement? The Where clause in SQL should be the same (enclosing strings in single quotes of course). If there is no table field qualification then the statement below is ok.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Tuesday, May 11, 2010 2:51 PM To: arslist@ARSLIST.ORG Subject: Re: {Remedy ARS} Re: COLCOUNT not working 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 at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"