Skip to main content
Nintex Community Menu Bar

Where are Attachment save in the K2 database

  • November 19, 2018
  • 3 replies
  • 241 views

Forum|alt.badge.img+3

Hello all,

 

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

 

 

3 replies

Forum|alt.badge.img+16
  • November 19, 2018

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. 


Forum|alt.badge.img+3
  • Author
  • November 27, 2018

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


Forum|alt.badge.img+16
  • November 27, 2018

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.