none
MSPS2013 - Related Items - Info in [dbo].[MSP_WssDocument] and [dbo].[MSP_WssListItemAssociation] and Icons on Task Level RRS feed

  • Question

  • Hi!

    1. The mistake is that the Russian version MSPS2013 binding written to the database [dbo]. [MSP_WssDocument] only if the document will be stored in the library "Assets Site" project site.

    SELECT TOP 1000 [ProjectUID]
          ,[DocumentUniqueID]
          ,[DocumentID]
          ,[Title]
          ,[CreateByResource]
          ,[CreateByUserClaimsAccount]
          ,[CreatedDate]
          ,[ModifiedByResource]
          ,[ModifiedByUserClaimsAccount]
          ,[ModifiedDate]
          ,[IsFolder]
          ,[ItemRelativeUrlPath]
      FROM [ProjectWebApp].[dbo].[MSP_WssDocument]

    ProjectUID DocumentUniqueID DocumentID Title CreateByResource CreateByUserClaimsAccount CreatedDate ModifiedByResource ModifiedByUserClaimsAccount ModifiedDate IsFolder ItemRelativeUrlPath
    32692399-65CB-E211-9438-6CF04974EFFB FDE1DA0A-4F6D-4F28-A764-57BEB9626F8A 1 NULL Системная учетная запись i:0#.w|sharepoint\system 2013-06-02 13:26:29.000 Системная учетная запись i:0#.w|sharepoint\system 2013-06-02 13:26:29.000 0 SiteAssets/TestDocFile1.docx

    In English. version of the platform is only the library "Documents".

    ProjectUID DocumentUniqueID DocumentID Title CreateByResource CreateByUserClaimsAccount CreatedDate ModifiedByResource ModifiedByUserClaimsAccount ModifiedDate IsFolder ItemRelativeUrlPath
    9E751330-2B6B-E211-93FC-6CF04974EFFB 7C052F22-5C82-429C-BC53-23652FEC4AEA 1 NULL Системная учетная запись i:0#.w|sharepoint\system 2013-03-26 03:11:08.000 Системная учетная запись i:0#.w|sharepoint\system 2013-03-26 03:11:08.000 0 Shared Documents/pro_wf_4.5.pdf



    2. The second point - blank table in both locales platform [dbo]. [MSP_WssListItemAssociation]

    SELECT TOP 1000 [ProjectUID]
          ,[ListItemUID]
          ,[RelatedProjectUID]
          ,[RelatedItemUID]
          ,[RelationshipTypeID]
      FROM [ProjectWebApp].[dbo].[MSP_WssListItemAssociation]

    Result: Null

    3. Lack of icons "Document" at the task in the project when you add a document to a task as it was in MSPS2010


    Any help!
    • Edited by Office4 Monday, June 3, 2013 9:05 PM
    Monday, June 3, 2013 9:03 PM

All replies

  • Error with reference to the tasks of the project to the documents in the June CU 2013 is not fixed.
    Links, as earlier in the Russian version of the PWA can be seen only with the "Site Assets".
    Saturday, July 6, 2013 7:30 AM