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 <[email protected]> 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 <[email protected]> > To: [email protected] > 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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"
