RFL200024: RayFlow 1.10 SP1 Known Issue - Test project does not contain any client color values for its phases.

This issue only affects clean installs of RayFlow 1.10.x

 

The following SQL queries which can be run together rectifies this issue allowing the RayFlow Clients General Report page to display coloured bars: 

 

UPDATE TaskList

SET ClientColor = 'CC0033'

WHERE TaskName = 'COD'

--AND ProjectID = 'ProjectID'

 

UPDATE TaskList

SET ClientColor = '99CCFF'

WHERE TaskName = 'EVAL'

--AND ProjectID = 'ProjectID'

 

UPDATE TaskList

SET ClientColor = '00CC66'

WHERE TaskName = 'PKG'

--AND ProjectID = 'ProjectID'

 

UPDATE TaskList

SET ClientColor = '990099'

WHERE TaskName = 'PO'

--AND ProjectID = 'ProjectID'

 

UPDATE TaskList

SET ClientColor = 'FF6600'

WHERE TaskName = 'POA'

--AND ProjectID = 'ProjectID'

 

UPDATE TaskList

SET ClientColor = '009999'

WHERE TaskName = 'QA'

--AND ProjectID = 'ProjectID'

 

UPDATE TaskList

SET ClientColor = '330099'

WHERE TaskName = 'UAT'

--AND ProjectID = 'ProjectID'

 

 

 

Note:  If multiple projects already exist, run the following query to obtain the ProjectID for the default Test project, and then remove the two hyphens from in from of the AND clause, add the ProjectID to that line and then run the queries. 

 

SELECT ProjectID FROM Projects WHERE ProjectName = 'Test'

 

Have more questions? Submit a request

Comments

Powered by Zendesk