Where are Attachment save in the K2 database

  • 19 November 2018
  • 3 replies
  • 110 views

Badge +3

Hello all,

 

Where in the K2 database does the attachment object save the binary data of the file?

 

 


3 replies

Userlevel 6
Badge +16

Hi,


 


It will depend on the type of SmartObject that is setup as datasource for Smartforms control or as a View's data source. If you are using SmartBox SmartObject, then it would be in K2 database. For example, I have a SmartBox SmartObject 'test_SmartObject', you will find the table in K2 database under the 'dbo.test_SmartObject' name. 

Badge +3

Do you have a sample view and smartobject I can look at?

Userlevel 6
Badge +16

Hi,


 


I'm assumed that you are using SmartBox SmartObject for this scenario. You can build a simple SmartBox SmartObject to confirm this. In K2 Five (5.2), the table is now located in SmartBox schema. In early Blackpearl versions, the same table is called 'dbo.name_of_the_SmartObject'.


 


1. Create a Smartbox SmartObject.



2. Generate a view from this SmartObject.


3. Run a view and create a new item with an attachment.



4. Check SmartBoxData.Sample5_SMO1 table.



 

Reply