paul.maxwell

CA PPM/MS Project Interface Field Mapping portlet

Blog Post created by paul.maxwell on Jan 12, 2016

Although not frequently used Clarity/CA PPM has enabled extension to the MS Project interface field mappings. However up to V13.x (at least) there has been no in built visibility to that mapping. For this who need it here is an NSQL query that can build a grid portlet like this:

 

msp-interface-mapping-v13-clarity.PNG

 

select

   @select:dim:user_def:implied:MSPMAP:prid:prid@

,  @select:dim_prop:user_def:implied:MSPMAP:clarity_name:clarity_name@

,  @select:dim_prop:user_def:implied:MSPMAP:mspname:mspname@

,  @select:dim_prop:user_def:implied:MSPMAP:prtype:prtype@

,  @select:dim_prop:user_def:implied:MSPMAP:prflags:prflags@

,  @select:dim_prop:user_def:implied:MSPMAP:record_type:record_type@

,  @select:dim_prop:user_def:implied:MSPMAP:behaviour:behaviour@

,  @select:dim_prop:user_def:implied:MSPMAP:custom_attribute:custom_attribute@

,  @select:dim_prop:user_def:implied:MSPMAP:is_customized:is_customized@

from (

        select

          m.prid prid

        , m.prname clarity_name

        , m.mspname mspname

        , m.prtype prtype

        , m.prflags prflags

        , (

            case m.prtype

            when 1 then 'Project'

            when 2 then 'Resource'

            when 3 then 'Task'

            when 4 then 'Assignment'

            when 5 then 'Team'

            else 'INVALID' end) record_type

        , (

            case m.prflags

            when 1 then 'Import to Clarity'

            when 2 then 'Export from Clarity'

            when 3 then 'Bidirectional'

            else 'INVALID' end) behaviour

        , (

            case

            when m.prname = lower(m.prname) then 1

            else 0 end) as custom_attribute

        , (

            case

            when m.prid not in (1,2,3,4,9,17,18) then 1

            else 0 end) as is_customized

        from     mspfield m

    ) msp_map

where @filter@

/*

query id = ut_sa_msp_map

member of utility family

*/

Outcomes