[Anthill-pro] Current Activity tab

[Uldis Karlovs-Karlovskis]

I`ve changed both but strange that after rollbacking Current Activity tab
disabling it is still inaccessible...

Uldis Karlovs-Karlovskis, C. T. Co
uldis.karlovs-karlovskis at ctco.lv
 

-----Original Message-----
From: anthill-pro-bounces at lists.urbancode.com
[mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Yanko, Curtis
Sent: ceturtdiena, 2008. gada 24. janvārī 20:37
To: rws at urbancode.com; AnthillPro user and support list.
Subject: RE: [Anthill-pro] Current Activity tab

There are multiple entries that come upwhen I search on
BUILD_LIFE_ACTIVITY_SUMMARY, which one do I want?

ACTIVE_BUILD_LIFE_ACTIVITY_SUMMARY or

RUNNING_BUILD_LIFE_ACTIVITY_SUMMARY
 

===
-Curt
W: 860.702.9059
M: 860.881.2050

-----Original Message-----
From: anthill-pro-bounces at lists.urbancode.com
[mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Ryan Smith
Sent: Thursday, January 24, 2008 12:45 PM
To: AnthillPro user and support list.
Subject: Re: [Anthill-pro] Current Activity tab

Uldis,

I think we actually found a bug in Oracle that creates a unnecessary
Cartesian product when joining tables. We have found a way around it
though.

You will need to replace a SQL statement in the
com.urbancode.anthill3.dashboard.Dashboard.sql.xml file in the server's
conf/sql directory. Search for 'BUILD_LIFE_ACTIVITY_SUMMARY' and replace
the SQL statement with:


      SELECT DISTINCT
          WC.BUILD_LIFE_ID,
          P.ID AS PROJECT_ID,
          P.NAME AS PROJECT_NAME,
          WC.ID AS CASE_ID,
          WC.WORKFLOW_ID,
          W.NAME AS WORKFLOW_NAME,
          WC.STATUS AS STATUS,
          WC.START_DATE,
          UR.USER_ID AS HAS_PERMISSION
      FROM
          WORKFLOW_CASE WC
              JOIN WORKFLOW W ON WC.WORKFLOW_ID = W.ID
              JOIN PROJECT P ON W.PROJECT_ID = P.ID
              LEFT OUTER JOIN SEC_RESOURCE SR ON SR.HANDLE_ID = W.ID
                AND SR.RESOURCE_TYPE_ID = 4
              LEFT OUTER JOIN SEC_PERMISSION SP ON SP.RESOURCE_ID =
SR.ID
               AND SP.RESOURCE_ACTION = 'execute'
              LEFT OUTER JOIN SEC_USER_ROLE UR ON SP.ROLE_ID =
UR.ROLE_ID
               AND UR.USER_ID = ?
      WHERE
          WC.WORKFLOW_ID = W.ID AND
          W.PROJECT_ID = P.ID AND
          WC.STATUS IN ('Running', 'Suspended', 'Waiting on Agents',
'Queued', 'Aborting' )
      ORDER BY WC.START_DATE DESC, WC.BUILD_LIFE_ID, HAS_PERMISSION




Save the file and restart the server.


Ryan

Steve Boone wrote:
> Uldis,
> 
> There seems to be an issue with one of the SQL queries we are running 
> in Oracle, we are trying to come up with a workaround for the issue.
> 
> Regards,
> Steve Boone
> 
> On 1/14/08, *Uldis Karlovs-Karlovskis* <uldisk at ctco.lv 
> <mailto:uldisk at ctco.lv>> wrote:
> 
>     Hello!
> 
>      
> 
>     Does Current Activity tab still should don`t work or Oracle? I`m
on
>     3.4.7 but it is still hunging up :(
> 
>      
> 
>     //Uldis Karlovs - Karlovskis//
> 
>     //Build System and Deployment Administrator//
> 
>     //System Configuration Management//
> 
>     //C.T.Co <http://C.T.Co>//
> 
>     //Mobile////: +371 29 345 210//
> 
>      
> 
> 
>     _______________________________________________
>     Anthill-pro mailing list
>     Anthill-pro at lists.urbancode.com
>     <mailto:Anthill-pro at lists.urbancode.com>
>     http://lists.urbancode.com/mailman/listinfo/anthill-pro
> 
> 
> 
> ----------------------------------------------------------------------
> --
> 
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro

--
===========================================================
Ryan Smith.           		2044 Euclid Ave., Suite 600
Lead Developer                  Cleveland, Ohio 44115
Urbancode, Inc.
                                email:  rws at urbancode.com
web:     www.urbancode.com      phone:  216-858-9000
web:     www.anthillpro.com     fax:    216-858-9602
===========================================================
_______________________________________________
Anthill-pro mailing list
Anthill-pro at lists.urbancode.com
http://lists.urbancode.com/mailman/listinfo/anthill-pro


This e-mail, including attachments, may include confidential and/or 
proprietary information, and may be used only by the person or entity to 
which it is addressed. If the reader of this e-mail is not the intended 
recipient or his or her authorized agent, the reader is hereby notified 
that any dissemination, distribution or copying of this e-mail is 
prohibited. If you have received this e-mail in error, please notify the 
sender by replying to this message and delete this e-mail immediately.

_______________________________________________
Anthill-pro mailing list
Anthill-pro at lists.urbancode.com
http://lists.urbancode.com/mailman/listinfo/anthill-pro