reporting on Enterprise Resource Multi_Value data

[TroyS]

has anyone run across reporting on the multi-value Resource Enterprise
Outline Codes?
For example, i have Ent Ouline Code 23 for Certifications which is a
multi-value select list

In project pro, I can insert Ent Outline Code 23 either as a single value
column or i see a separate MV-Ent Outline Code 23 listed and can be inserted
separately.

I'm trying to pull the multiple values checked for each resource into a
custome report, but i'm not seeing how those multiple values are being
stored in the database.

any suggestions? thx.

 

[Ed Morrison]

The attached query returns the resource name, the outline code node, and the
full outline code name. The key table is msp_mv_fields.

Select r.res_name, oc.oc_name, oc.oc_cached_full_name
from msp_projects p
inner join msp_outline_codes oc
on oc.proj_id=p.proj_id
inner join msp_mv_fields mv
on mv.code_uid=oc.code_uid
inner join msp_resources r
on r.res_uid=mv.code_ref_uid
and r.proj_id=mv.proj_id

where p.proj_type=2
and oc.oc_field_id=205521526
and r.proj_id=1

 

[TroyS]

thanks very much....it just didn't seem that msp_mv_fields was the right
table ...