Balas Blog..

Sharing knowledge in Project, Program, Portfolio Innovation Management (PPIM) and various Technology.

Showing posts with label Clarity Queries. Show all posts

Showing posts with label Clarity Queries. Show all posts

Sunday, April 3, 2016

Extract Task Queries

select inv.code ""Project ID"", inv.name ""Project Name"", (select name from CMN_LOOKUPS_v where ...

Tuesday, March 29, 2016

Get Project Data using Clarity

select inv.code "Investment ID", inv.name "Name", inv.description "Description", ( select cmn.last_name||...

Group Extract Query In Clarity

"SELECT srm.last_name ""Last Name"", srm.first_name ""First Name"", srm.unique_name "...

Get Active Resources From Clarity

SELECT srm.last_name "Last Name", srm.first_name "First Name", srm.unique_name "Resource ID", srm.email ...

Query To Extract Team In Clarity

select inv.code "Investment ID", inv.name "Name", srm2.unique_name "Team Resource ID", tem.team_uid "Te...

View web version

About Me

Bala

View my complete profile

Powered by Blogger.