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 <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"