Hi Mark, Just checked, it is set to default value 0. Thank you, Raj
On Wed, May 12, 2010 at 7:28 AM, Brittain, Mark <[email protected]>wrote: > 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]<arslist%[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]<arslist%[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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
