Hi,

I am upgrading from PS2010 to SP2013 (on prem).   I have a report that uses this view "MSPCFPRJ_ITS Initiative_AssociationView" for a multi choice ECF (see syntax below).  After the upgrade I do not see this table anymore.

Is there a replacement table or do I need to change the syntax?

Tx

Andrew

FROM MSP_EpmProject_UserView

INNER JOIN

   (SELECT   MSP_EpmProject_UserView.ProjectUID

            ,ISNULL(STUFF((SELECT ', '+ MemberValue

    FROM [MSPLT_ITS Initiative_UserView]

    INNER JOIN [MSPCFPRJ_ITS Initiative_AssociationView]

    ON [MSPLT_ITS Initiative_UserView].LookupMemberUID =

    [MSPCFPRJ_ITS Initiative_AssociationView].LookupMemberUID

    WHERE [MSPCFPRJ_ITS Initiative_AssociationView].EntityUID =

    MSP_EpmProject_UserView.ProjectUID

    FOR XML PATH(''), TYPE

    ).value('.','varchar(max)')

    ,1,2, ''),'')AS [ITS Initiative]

FROM    MSP_EpmProject_UserView

GROUP BY ProjectUID ) MVList

ON MSP_EpmProject_UserView.ProjectUID = MVList.ProjectUID

Hi Andrew,

The view should be the same (I just checked the view for one of my client's reports which uses a multiple choice field). Maybe something went wrong during the upgrade!

If everything else works as expected I would suggest:

- checking the custom field settings (check if multiple settings is enabled)

- re-save the custom field

- administrative backup and restore of the custom fields

Hope this helps

Paul