SOLVED

How can I decode [ASSN_BINARY_DATA] and [ASSN_CONTOUR_DATA] in [WSS_PWA].[pjpub].[MSP_ASSIGNMENTS]?

%3CLINGO-SUB%20id%3D%22lingo-sub-2791465%22%20slang%3D%22en-US%22%3EHow%20can%20I%20decode%20%5BASSN_BINARY_DATA%5D%20and%20%5BASSN_CONTOUR_DATA%5D%20in%20%5BWSS_PWA%5D.%5Bpjpub%5D.%5BMSP_ASSIGNMENTS%5D%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2791465%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3EHow%20can%20I%20decode%2Fencode%20%5BASSN_BINARY_DATA%5D%20and%20%5BASSN_CONTOUR_DATA%5D%20in%20%5BWSS_PWA%5D.%5Bpjpub%5D.%5BMSP_ASSIGNMENTS%5D%20Project%20Server%202019%20table%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2793349%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20decode%20%5BASSN_BINARY_DATA%5D%20and%20%5BASSN_CONTOUR_DATA%5D%20in%20%5BWSS_PWA%5D.%5Bpjpub%5D.%5BMSP_ASSIGNMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2793349%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1082084%22%20target%3D%22_blank%22%3E%40Vasily_Zaytsev%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EIt%20is%20not%20supported%20query%20that%20table%20%2F%20schema%20directly%20with%20SQL%2C%20only%20the%20pjrep%20schema%20is%20supported.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hello.

How can I decode/encode [ASSN_BINARY_DATA] and [ASSN_CONTOUR_DATA] in [WSS_PWA].[pjpub].[MSP_ASSIGNMENTS] Project Server 2019 table?

 

1 Reply
best response confirmed by Vasily_Zaytsev (Contributor)
Solution

Hello @Vasily_Zaytsev ,

It is not supported query that table / schema directly with SQL, only the pjrep schema is supported. 

Paul