SmartObject issue is Roles

  • 26 February 2015
  • 1 reply
  • 0 views
N
Badge +5

Hi Mates,

 I have  created one store procedure which fetch data from SQL table

 

SELECT * FROM K2_ApprovalList
ORDER BY Sequance ASC

 

And Then i had created smartobject base on this procedure and added that in my k2 Roles.

Now my problem is 

1. Though my SO return data in sequence but while assign the request it will assign the request randomaly or say on Alphabatically. How i can reslove this issue. I want assignment done in sequnce only.

2. Can we used procedure base SO in Roles. if we added that can it add that entry in DestinationUser table???

1 reply

J
Badge +5

 

For your qn1:

 

Based on documentation

"When a role is used as a destination, instances are created in the order in which the role membership is returned from the server query. If a specific order is required, rather use individual users instead, and specify the users in the desired order."

 

http://help.k2.com/onlinehelp/k2blackpearl/UserGuide/4.6.9/webframe.html#Destination_Rule-Destination_Rule_Options.html

 

 

qn2:

Roles accepts SmartObjects and thus, it will accept your query to the Stored Procedures. Why not add the SmartObject method (to the SP with sorting) directly in the Destination Rule?

 

 

JK.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings