K2 blackpearl

i have 3 views View 1,view 2 ,view 3view 1 has one  text box control(food varities).view 2 has two control 1.people name(text box), 2.multi select (look up fromthe first view,food varities).view 3 has two control 1.multi select(look upfrom the second view control, people name),2.multi select (look up fromthe first view,food varities).When i select 2 people name from the first control ,2nd control should populate only the foods the 2 people selected,if two people have selected same food must be only once. Please Find Below I have Attached Images For Better Understanding

Hi, I would like to remove a row from editable list. I have used a condition  ' for Selected row' ,  with action 'remove the selected row from the editable list'. this code i have used on a button. but i have to press twice the button to get the job done. Is it possbile to get the job done pressing the button only one time.  Thanks with Regards,JD

 The upgrade of SharePoint 2010 to 2016 is not an easy matter (to say the least). I've prepared a summary describing the process (Refer below image) The main challenge is the migration of SharePoint V1 / SharePoint V2 / SharePoint Content service broker SmartObjects. Which we (Unfortunately) have a lot of these in our environment. I want to know if the plan below is good, or is there a better way of doing things?I can go through details if required. Or about why we're choosing this upgrade path, etc.. Thanks in advance EDIT: Picture also attached (in case it doesn't load) 

I have a workflow that basically kicks off a stored procedure to run after an ETL tool drops items into a database staging table.  Part of the workflow counts the number of items added to the actual work items table from the staging table.  I have it scheduled to run once per hour. It works well. Unfortunately, sometimes the ETL fails or has an issue and the workflow will happily write 0 items to the work items table because it doesn't know any better. I'd like to set up a a path in the workflow that if 0 items get written, it sends me an email letting me know.   As the workflow runs once an hour (even after business hours) and I do NOT want it to send me an email on any 0 items written instance between say 6pm and 7am the next morning, I'd like to put as part of the line rule for it to only execute the email action when the time is between 6pm and 7am.   I'm sure that's possible via an expression but I'm having a hard time coming up with it

I have created associations between sevaral smart objects in a single SQL service broker, what I need to know is what next!? How do I leverage the smart object association using rules etc? Where would I see the SMOA in action? Basically I want to use the association like a SQL join but I Don;t know if this is the correct approach? Any suggestions would be gratfully received!

Hi, Is it possible to assign an OU to the process rights of a process? Currently i have start rights for a Group, but the form+workflow will be accessed by users in a nested OU. Form security is done via the Usersinanyorganizationalunit AD method But how do you accomplish this on the workflow side of things? Thanks

On SharePoint, I have 2 list: MyWorkflowList and MyList.MyList has a column "RoleName", and the values are :-Admin-Approver MyWorkflowList is a Sub Workflow, called manually from another workflow. MyWorkflowList has a "Get List Item Reference".On the "Specify the list containing the list item to reference", I select "MyList".On the "Specify filters for creating the reference", I select "RoleName" with value = ApproverI set the "Reference Name" to be "Events Approver" During execution/runtime when it gets to this stage, I am getting an error "Object reference not set to an instance of an object" How can I fix this error ? Thank you.

I have a form in master detail format.. i.e. header and multiple line items. I need to show form data in email. Header part shows fine in email in HTML format. How to show detail part (Product details) in below screenshot. 

Have a Form with their approval levels. With buttons defined for each action "Approve", "Reject" worked great executing the Action Work List Item, selecting the params Serial, selecting the correct workflow, and typing the name of the action. Somehow this workflow got disasociated from the main form and is not triggering the approve action. Any ideas on how to get this working? I was trying to avoid the issue of having to re-mapped the SMO Object References everytime the Workflow is edited and trying to have only 1 view, but cause the issue. THX Dinooz.

Using K2 Studio, is it possible to execute a ruledo a check before an escalation is fired on a client event? The actual escalation I currently use is a go-to-activity, that then loops back to the original client event after a period. I need to be able to check: Did it escalate before? If Yes, don't escalateIf No, escalate This will ensure the escalation (being a go-to-activity) only happens once. Thanks

Hi All,How can I impersonate user to check if the user has right to view/approve the quotation by passing username and serial number to check?Is it possible to similar to  K2Conn.ImpersonateUser(@ "K2:domainusername"); ??My purpose is only use username to impersonate him to approve the task, no need to pass his password. Thanks a lot.

I have form that loads some excel data into my MS SQL database, and when the data is loaded, it triggers my workflow to use the 'execute' SmartObject from the MS SQL stored procedure. The stored procedure has a merge statement that does something, followed by a delete and finally an update (in that order). The issue: When the workflow executes, the merge and update statements  run perfectly fine, but delete statement does nothing. My guess is it is not being executed. The delete statement is a simple: DELETE FROM dbo.tableSo I tried usingTRUNCATE TABLE dbo.tablethinking is was an issue with the DELETE statement. Nope, still does not change anything. I execute the stored procedure in MS SQL Server and it runs just fine. Anyone know what the issue is? 

Hi, I'm running blackpearl version 4.7 (with August cumulative updates installed), and am doing the tutorial for the Temporary Access Application.  I'm in section 100EDI, Part 1 Workflows in K2 Studio, on Exercise 1, Part 3 - testing the application. I've created the four requests, approved them via my task list in Workspace, but all four requests remain at the Approval activity.  If I use the Process Overview report, I can see the Approval activity has a Start Date, but no Finish Date; if I drill down on Approval, it shows Status of Completed, by my user, with a start and finish date.  If I drill into the Flow, I only see the Start in green; the Approval is blue, like it hasn't completed.  If I drill into Approval, Status is Active, but the Participants only shows my user, and indicates the Status is Completed, and Action was Approved.  It's like the flow is waiting on some other task/action, although it recognizes that I completed the Approved step.  Th

I have a WCF service method that expects an object as a parameter.  So the method is "UpdateDB(myobj)" and myobj is simply composed of a string name, datetime startdate and int age.  I don't want to change the method to accept three different values.  I have the service configured using a WCF endpoint in the service tester and created a smartobject from that method.  I want to call this method from within a workflow...I assume from the smartobject event.  I have the 3 values available in three process data fields.    Is there a best way to construct the object with the data fields in order to pass the object into the method? I assume the serialize/deserialize methods will come into play but I'm unclear on how to do this.  Thanks.

Hi all, Currently i am facing a small bug in k2 list view.For example, my column is quantity column which allow 3 decimal places.I am using List Sum Expression in K2 to sum the column but what do i get is rounding to 2 decimal places. Example:Desired Result: Quantity1.1231.234---------2.357 K2 Result: Quantity1.1231.234---------2.36 Anyone facing this issue as well? Regards,Kyo.

Hello Guys, Could some one help me with default REST Service which returns complete Worklist. I'm aware of this Endpoint http://k2-denallix/k2services/REST.svc/Worklist/Items which is returning only the worklist items of particular user running this URL. I would like to get complete worklist items of all users. Appreciate any Help!! Regards,Vijay.

Hi, please help me, i create package from k2 dev server and then i deploy on k2 prod server i get error :Dependency could not be created: System.Exception: Dependency could not be created. Parent does not exist in this environment. Check Data property of exception.at SourceCode.Hosting.Services.DependancyService.VerifyObjects(List`1 parents)at SourceCode.Hosting.Services.DependancyService.CreateDepenancyBatch(Dictionary`2 depenancyBatch)Dependency could not be created: System.Exception: Dependency could not be created. Parent does not exist in this environment. Check Data property of exception. at SourceCode.Hosting.Services.DependancyService.VerifyObjects(List`1 parents) at SourceCode.Hosting.Services.DependancyService.CreateDepenancyBatch(Dictionary`2 depenancyBatch)both of k2 dev and k2 prod have different environtment Thanks,Agus

Error is isolated to only one laptop. Form is based on sharepoint list and uses default file attachment controls/rules. Error shown is "File not loaded: An unexpected error occured, contact your system administrator". Where do I begin troubleshooting it?

Okay...I have a simple workflow that pulls in emails from a shared mailbox...some folks on this forum helped me get it to work.  Anyway, I had originally built it in Studio, but moved it to designer so it could be more easily editable.   Anyway, I figured out that I need to clear my staging table before starting the workflow, so I added a simple execution of a stored procedure as the first step of the workflow.   Now, however, when I try to deploy it, I get an error.   Attaching a diagram of the workflow with the new step outlined as well as a screenshot of the error.   Anyone have any ideas?  I had this issue once before, and when I simply rebuilt the workflow with the inserted step included in the original build, it worked fine.  I don't want to have to rebuild the workflow every time I insert a new step, however...that should not be necessary.   Thanks,Rob 

I've been waiting for years for the arrival of OOF task notifications to delegates.   We finally upgraded to 4.7 and tried out the OOF notifications.  While I am thrilled that the delegates now receive notification.... I was extremely disappointed that they receive a generic notification that tells them nothing and looks like spam.   We spend much thought and effort on our task notifications; we try to make them as informative and helpful as possible to our end users.  Users receive LOTS of email and they need to be able to easily and quickly understand the task so that work can be done efficiently.    These generic notifications are frankly embarassing.  I had assumed that the delegate notification would be the configured task notifications that the destination users receive.  Is there any way to change this notification or force the configured task notification that the destination user receives to be sent to the delegate?   

Hi, I am using Endpoint Assembly to send form fields values to external system. I created custom SmartObject base on method from endpoint assembly.  Every time when form call custom SmartObject and trying to send empty field Form throws the error "SmartObject property field1 is a required property for selected method Read. Value must be set.". Not all fields on my form is mandatory. How to tell SmartObject do not validate those fields? Regards,  Oleg 

Hi, I have one parent workflow which is calling a child workflow through IPC event. Now in child workflow, one task is being is created for action. If the task outcome is rejected, a new task should be re-created for the one who approved the task in parent workflow. I hope I made the requirement clear, please do let me know if you need more inputs. Any thoughts, ideas would be highly appreciated. Regards,Ram 

Hi, Is there any way to see smartObject related data on View Flow action?  Thanks a lot

Hi, Is there any way to send a personalized email when sharing a task? Thanks a lot

Hi All, I am new in K2-Blackpearl. My requirment is , i would like to restict entry for a column of the view only number. Other then number, the column should not accept any type of value. I have tried with a pattern - (^[1-9]d{0,2}(.d{3})*(,d)?$) , but this did not work. It will be nice, if you can help me in this regards. Thanks in advance,JD