Gary, Actually ...there is a difference between COLCOUNT and a "ROWCOUNT" function.
REF: BasicGuide-630.2006.05.09.pdf Pg 647 " COLCOUNT (column) or (table) " <snip> " For a table or results list field, returns the total number of rows. For a column field, returns the total number of non-NULL rows in a given column. " So if you call COLCOUNT and pass it a reference to a Table field then it does a "row count". However, if you pass it a column of a table then it counts the non-null rows in that column. The reason that can be very helpful is if you are using the updatability of columns. (For example.) The user may want/need to know that there are N rows that need attention before they can continue with a given task. So... as implemented, Remedy's COLCOUNT function is a super set of what ROWCOUNT could do if it worked the way I think you would want it to work. But I am not clear as to what the number would be if table chunking was involved. I would guess that it would give you the current chunk size and not the total number of records in all of the data chunks. So if your feeling chunky in your table fields... do some testing if you want the Total total instead of the chunk total. But I think $ LASTCOUNT $ should always get the Total total just after the table was refreshed in an active link. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Wed, Jan 7, 2009 at 4:29 PM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH <gary.opela....@tinker.af.mil> wrote: > Hey, that looks like it might just work. I don't know why they don't > call it ROWCOUNT. > > From the 6.3 documentation: > > COLCOUNT > (column) or (table) > int > > For a table or results list field, returns the total > number of rows. > For a column field, returns the total number of > non-NULL rows in a given column. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Greg Donalson > Sent: Wednesday, January 07, 2009 3:27 PM > To: arslist@ARSLIST.ORG > Subject: Re: Active Link works on dev; not on prod > > Hi Gary, > > You can always do 'Ticket Count' = COLCOUNT($tbl_Tickets$). I would > suggest using this - I do not like to rely on LASTCOUNT. > > Greg Donalson > Schlumberger > > Desk - 713-513-2331 > Cell - 281-515-6538 > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 > CS/SCBAH > Sent: Wednesday, January 07, 2009 3:15 PM > To: arslist@ARSLIST.ORG > Subject: Re: Active Link works on dev; not on prod > > The solution; use the $LASTCOUNT$ keyword. Since I'm running it > immediately > after refreshing the table, it should always pull the correct count. > > Gary _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
