Hi Raj, In the table properties go to the Advanced Display. There under Data Chunking there is a field named Chunk Size or Size of Chunk depending on your version. The default is 0 which means unlimited number of records are displayed. Not sure if the chunking would affect the column count but figure it is worth checking.
FYI Mark -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Raj Sent: Tuesday, May 11, 2010 3:52 PM To: [email protected] Subject: Re: {Remedy ARS} Re: COLCOUNT not working Thank you Mark for the reply. Where can I check the Table Chunking value? On May 10, 12:03 pm, "Brittain, Mark" <[email protected]> wrote: > 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:[email protected]] On Behalf Of Raj > Sent: Monday, May 10, 2010 2:21 PM > To: [email protected] > 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 <[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 atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "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 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
