Skip to main content
Nintex Community Menu Bar

Within SmartForms we have the ability to add comments to rules so we can annotate the logic being used in the rules.

 

Is that little comment control able to be used in a Smart Form we develop?

Hi Audrey,


 


You will need to write a stored procedure to pull this data for you from the K2 DB.


 


First of all you will need the ViewID, you can find it in the following table:


 


[K2].[Form].[View]


 


Now if you want to list the comments of the view actions, you will need to querey all the action from:


 


[K2].[Form].[ActionItem]


 


This table has a column that contains the comment for each action, the column name is Properties (xml)


 


The node name that contains the comment inside the XML looks like :


 


<Property>
<Name>Comments</Name>
<Value>[YOUR COMMENT]</Value>
</Property>


 


Hope that helps.


 


Reply