Re: Active Link works on dev; not on prod
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 eitherAND if table chunking affects things. Steve On Jan 7, 5:44 pm, Joe DeSouza joe_rem...@yahoo.com 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 gary.opela@tinker.af.mil To: arsl...@arslist.org 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:arsl...@arslist.org] On Behalf Of Greg Donalson Sent: Wednesday, January 07, 2009 3:27 PM To: arsl...@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: arsl...@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 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 07, 2009 2:54 PM To: arsl...@arslist.org 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:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arsl...@arslist.org 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
Re: Active Link works on dev; not on prod
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
Re: Active Link works on dev; not on prod
Carey, I understand what you are saying, but either way you use colcount, it's still counting rows, not columns. That's what my point was, colcount is not something I would have ever looked at by its name and though, Oh, I'll bet this function will count the number of rows. Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Thursday, January 08, 2009 8:15 AM To: arslist@ARSLIST.ORG Subject: Re: Active Link works on dev; not on prod 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Active Link works on dev; not on prod
So the Remedy function COLCOUNT() has no bearing if the table field is chunked? I distinctly remember having some issue with something similar in the past but not sure if it was with COLCOUNT() or something else.. Or maybe it was a limitation of that version?? Joe Carey, I understand what you are saying, but either way you use colcount, it's still counting rows, not columns. That's what my point was, colcount is not something I would have ever looked at by its name and though, Oh, I'll bet this function will count the number of rows. Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Thursday, January 08, 2009 8:15 AM To: arslist@ARSLIST.ORG Subject: Re: Active Link works on dev; not on prod 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. From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH gary.opela@tinker.af.mil To: arslist@ARSLIST.ORG Sent: Thursday, January 8, 2009 9:19:52 AM Subject: Re: Active Link works on dev; not on prod ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Active Link works on dev; not on prod
Hello everyone, We have an issue when scheduling a billing archive job through the CMDB. The scheduled job is not triggering to run at the scheduled time which causes us billing issues. What we are doing is rebooting the server and then rescheduling the job and then it runs fine. Has anyone had these issues before ? We currently run Version 7.0.1 Window platform DB = Sql server Thanks Rick. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Thursday, January 08, 2009 9:17 AM To: arslist@ARSLIST.ORG Subject: Re: Active Link works on dev; not on prod So the Remedy function COLCOUNT() has no bearing if the table field is chunked? I distinctly remember having some issue with something similar in the past but not sure if it was with COLCOUNT() or something else.. Or maybe it was a limitation of that version?? Joe From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH gary.opela@tinker.af.mil To: arslist@ARSLIST.ORG Sent: Thursday, January 8, 2009 9:19:52 AM Subject: Re: Active Link works on dev; not on prod Carey, I understand what you are saying, but either way you use colcount, it's still counting rows, not columns. That's what my point was, colcount is not something I would have ever looked at by its name and though, Oh, I'll bet this function will count the number of rows. Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Carey Matthew Black Sent: Thursday, January 08, 2009 8:15 AM To: arslist@ARSLIST.ORG Subject: Re: Active Link works on dev; not on prod 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. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
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
Re: Active Link works on dev; not on prod
Permissions? -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 2:50 PM To: arslist@ARSLIST.ORG 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 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
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:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arslist@ARSLIST.ORG 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
Re: Active Link works on dev; not on prod
Testing on my admin account :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, January 07, 2009 2:54 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link works on dev; not on prod Permissions? -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 2:50 PM To: arslist@ARSLIST.ORG 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 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Active Link works on dev; not on prod
Okay, you led me to the answer. On dev, the default for the field used in the EXTERNAL() call for the table qualification would result in 1 ticket, and it was by default highlighted. So, whenever I changed the menu, which would in turn change the value in the field referenced in the EXTERNAL() call, it would update the table, and would keep that same ticket highlighted. That ticket happened to always be the last ticket in the table, so I was getting the number of rows, essentially. Now, on production, there were no records returned by the default EXTERNAL() value. So, whenever I changed the field that the EXTERNAL() referenced, and the table refreshed, no records were highlighted, and that gave me a value of 0 for the table field. I will do some table looping or something to get a count. I wish I could use a ROWCOUNT('Table Field') function or something. Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 07, 2009 2:54 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arslist@ARSLIST.ORG 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 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
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:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 07, 2009 2:54 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arslist@ARSLIST.ORG 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 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Active Link works on dev; not on prod
Gary, You can get a count by running a direct SQL against the view of the form that table field is built on using the same condition as in the table field.. Select count(*) from view_name where condition Joe From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH gary.opela@tinker.af.mil To: arslist@ARSLIST.ORG Sent: Wednesday, January 7, 2009 4:11:59 PM Subject: Re: Active Link works on dev; not on prod Okay, you led me to the answer. On dev, the default for the field used in the EXTERNAL() call for the table qualification would result in 1 ticket, and it was by default highlighted. So, whenever I changed the menu, which would in turn change the value in the field referenced in the EXTERNAL() call, it would update the table, and would keep that same ticket highlighted. That ticket happened to always be the last ticket in the table, so I was getting the number of rows, essentially. Now, on production, there were no records returned by the default EXTERNAL() value. So, whenever I changed the field that the EXTERNAL() referenced, and the table refreshed, no records were highlighted, and that gave me a value of 0 for the table field. I will do some table looping or something to get a count. I wish I could use a ROWCOUNT('Table Field') function or something. Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 07, 2009 2:54 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arslist@ARSLIST.ORG 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
Re: Active Link works on dev; not on prod
Yeah, but the condition will change based on what the user chooses from a menu. I'm using EXTERNAL() in the table qual, and don't want to deal with maintaining all of the direct SQL version of the remedy searches from which the user could potentially pull. I used $LASTCOUNT$. If that would't have worked, I would have had to have used an active link to call an active link guide to call an active link that would increment a counter. Add in table looping, and it should work too. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, January 07, 2009 3:18 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link works on dev; not on prod ** Gary, You can get a count by running a direct SQL against the view of the form that table field is built on using the same condition as in the table field.. Select count(*) from view_name where condition Joe From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH gary.opela@tinker.af.mil To: arslist@ARSLIST.ORG Sent: Wednesday, January 7, 2009 4:11:59 PM Subject: Re: Active Link works on dev; not on prod Okay, you led me to the answer. On dev, the default for the field used in the EXTERNAL() call for the table qualification would result in 1 ticket, and it was by default highlighted. So, whenever I changed the menu, which would in turn change the value in the field referenced in the EXTERNAL() call, it would update the table, and would keep that same ticket highlighted. That ticket happened to always be the last ticket in the table, so I was getting the number of rows, essentially. Now, on production, there were no records returned by the default EXTERNAL() value. So, whenever I changed the field that the EXTERNAL() referenced, and the table refreshed, no records were highlighted, and that gave me a value of 0 for the table field. I will do some table looping or something to get a count. I wish I could use a ROWCOUNT('Table Field') function or something. Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 07, 2009 2:54 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arslist@ARSLIST.ORG 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 ACTLFor Schema - HD: My Stats ACTLLinked to field - Table Properties: (536870936) ACTLOn 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 ACTLTable 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 ACTLFor field -- Tickets (536870932) ACTL Refresh field ACTL 1: Set Fields ACTLTicket 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 ACTLFor Schema - HD: My Stats ACTLLinked to field - Table Properties: (536870936) ACTLOn 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 ACTLTable 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 ACTLFor field -- Tickets (536870932) ACTL Refresh field ACTL 1: Set Fields ACTLTicket Count: (536870937
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 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 07, 2009 2:54 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arslist@ARSLIST.ORG 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 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
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: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 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 07, 2009 2:54 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arslist@ARSLIST.ORG 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 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers
Re: Active Link works on dev; not on prod
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 gary.opela@tinker.af.mil To: arslist@ARSLIST.ORG 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: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 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 07, 2009 2:54 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arslist@ARSLIST.ORG 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