Portal Engine Questions on portal engine and web parts.
Version 7.x > Portal Engine > Create view for specific document type View modes: 
User avatar
Member
Member
Nel215 - 9/2/2013 2:14:33 AM
   
Create view for specific document type
Hi,

I want to create a database view for a specific type document ( say the doc type is "TestDocType"),
the view just need to list all the fields in that document type as columns and then all the values.

Thanks

User avatar
Kentico Legend
Kentico Legend
Brenden Kehren - 9/3/2013 9:49:07 AM
   
RE:Create view for specific document type
Run a query in SQL Server Management studio like this:
SELECT * FROM View_<NameSpace>_TestDocType_Joined
and see what you get...by default Kentico creates a view for you that has all document type and node information in it. If you look at the end of the view results, you'll see your custom document type columns.

Where <NameSpace> is replace that with your namespace value in the General tab of your custom document type.