Raj, Any chance the Table Chunking is set to 15? I know it is a wild thought but it is the only thing I can think of that might explain the behavior.
Mark -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: Monday, May 10, 2010 2:21 PM To: arslist@ARSLIST.ORG Subject: Re: {Remedy ARS} Re: COLCOUNT not working Hi Joe, Filter is on submit. Only one If Action Set Fields Action (Current Transaction- Current Transaction) FIELD NAME<--COLCOUNT($COLUMN NAME$) (There is only one column in the table, that DB ID of the column field is "COLUMN NAME" and DB ID of the field to be set is "FIELD NAME". I am doing the above action , please see below for more details: Set Fields Action Name FIELD NAME Value COLCOUNT($COLUMN NAME$) This COLCOUNT is not working properly, it is always setting the value "15" to the field FIELD NAME. Although I checked there are 20 entries in that column(Table). So the value should be 20 but it is 15. Thanks, Raj On May 10, 11:01 am, Joe DeSouza <joe_rem...@yahoo.com> wrote: > Raj, > > sum(fieldname) is the function used across most standard databases to do > something similar to a colcount() > > update table tablename set fieldname = sum(field2name) where your > conditions... > > Just curious - what are your actions on your filter that doesn't seem to work? > > Hope this helps.. > > Cheers > > Joe > > ________________________________ > From: Raj <ravi6...@gmail.com> > To: arsl...@arslist.org > Sent: Mon, May 10, 2010 11:41:19 AM > Subject: COLCOUNT not working > > 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" > > ___________________________________________________________________________ > ____ > 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" This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
