My question exactly. I thought the same thing, but would have to test. If they don't work (and I would never rely on LASTCOUNT) I would take the table field qualification and simply build a SQL Count statement to return the number of matching records. It would be safer, especially if the User has the number of records to be returned set to a smaller number in the User tool - not sure if that screws things up either....AND if table chunking affects things.
Steve On Jan 7, 5:44 pm, Joe DeSouza <[email protected]> wrote: > Does LASTCOUNT and COLCOUNT($ID$) work correctly when table chunking is > enabled? > > I don't remember so just thinking out loud here before you think its the > solution.. > > Joe > > ________________________________ > From: "Opela, Gary L CTR USAF AFMC 72 CS/SCBAH" <[email protected]> > To: [email protected] > Sent: Wednesday, January 7, 2009 4:29:56 PM > Subject: Re: Active Link works on dev; not on prod > > 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:[email protected]] On Behalf Of Greg Donalson > Sent: Wednesday, January 07, 2009 3:27 PM > To: [email protected] > 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:[email protected]] On Behalf Of Opela, Gary L CTR USAF AFMC 72 > CS/SCBAH > Sent: Wednesday, January 07, 2009 3:15 PM > To: [email protected] > 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 > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Grooms, Frederick W > Sent: Wednesday, January 07, 2009 2:54 PM > To: [email protected] > Subject: Re: Active Link works on dev; not on prod > > ** > > I thought setting an Integer field equal to a table puts the row number of > the currently selected row into the Integer field > > Fred > > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Opela, Gary L CTR USAF AFMC 72 > CS/SCBAH > Sent: Wednesday, January 07, 2009 2:50 PM > To: [email protected] > Subject: Active Link works on dev; not on prod > > AR Server 6.3/ WUT 6.3/ Windows 2k3/ MSSQLServer > > So, I just developed a form and some active links on dev, then imported them > into prod, and one of the ALs doesn't work. > > So, the active link does a set fields. It sets 'Ticket Count' = $tbl_Tickets$ > > On dev, this will set the Ticket Count integer field to the number of records > in the tbl_Tickets table. > > This works fine in dev, but not in prod. Below are the logs from each table > refresh: > > Dev: > > <WFLG> /* Wed Jan 07 2009 14:35:26 */ > <WFLG> Workflow Trace Log -- ON > <ACTL> /* Wed Jan 07 2009 14:35:28 */ > <ACTL> Start active link processing -- Operation - On Menu Choice > <ACTL> For Schema - HD: My Stats > <ACTL> Linked to field - Table Properties: (536870936) > <ACTL> On screen type - CREATE > <ACTL> Checking HD: MS: Set Table Qual on Table Properties: Change (10) > <ACTL> -> Passed qualification -- perform if actions > <ACTL> 0: Set Fields > <ACTL> Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( > 'Create Date' >= "04/01/2008") > <ACTL> Checking HD: MS: Refresh tbl_My Tickets (50) > <ACTL> -> Passed qualification -- perform if actions > <ACTL> 0: Set Characteristics > <ACTL> For field -- Tickets (536870932) > <ACTL> Refresh field > <ACTL> 1: Set Fields > <ACTL> Ticket Count: (536870937) = 21 > <ACTL> /* Wed Jan 07 2009 14:35:28 */ > <ACTL> Stop active link processing - On Menu Choice > <WFLG> /* Wed Jan 07 2009 14:35:34 */ > <WFLG> Workflow Trace Log -- OFF > > Prod: > > <WFLG> /* Wed Jan 07 2009 14:34:54 */ > <WFLG> Workflow Trace Log -- ON > <ACTL> /* Wed Jan 07 2009 14:35:02 */ > <ACTL> Start active link processing -- Operation - On Menu Choice > <ACTL> For Schema - HD: My Stats > <ACTL> Linked to field - Table Properties: (536870936) > <ACTL> On screen type - CREATE > <ACTL> Checking HD: MS: Set Table Qual on Table Properties: Change (10) > <ACTL> -> Passed qualification -- perform if actions > <ACTL> 0: Set Fields > <ACTL> Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( > 'Create Date' >= "04/01/2008") > <ACTL> Checking HD: MS: Refresh tbl_My Tickets (50) > <ACTL> -> Passed qualification -- perform if actions > <ACTL> 0: Set Characteristics > <ACTL> For field -- Tickets (536870932) > <ACTL> Refresh field > <ACTL> 1: Set Fields > <ACTL> Ticket Count: (536870937) = 0 > <ACTL> /* Wed Jan 07 2009 14:35:03 */ > <ACTL> Stop active link processing - On Menu Choice > <WFLG> /* Wed Jan 07 2009 14:35:09 */ > <WFLG> Workflow Trace Log - OFF > > Any help is greatly appreciated. > > Gary > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
