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 at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
