K2 blackpearl

Dear all,I am a newbie to K2 designer and I have a probelm in using Save Method to update data to one table. My intention is to update datum in one table from "P to "S".  Below is the Software spec:-MS SQL Server 2016-K2 Server version 4.7-Internet Explorer Browser version 11.0.42 By referring to the attachments, those are the basic configurations I made:"Attachment1.png", I have created one table in SQL server and created one SmartObject which link to newly created table."Attachment2.png", I have created one workflow which includes Step - Save Method -- Update bbbfinjournal. "Attachment3.png", I use same SmartObject to create item view with update function. I can update data from character "P" to any character.  After everything is ready, I created and deployed the workflow, and I clicked Button to trigger K2 Workflow.After that , I expected K2 update bbbfinjournal.statuscode to "S", but no joy, system didn't proceed the Save Method flow and meet my expectation.K2 did not update statu

Hello all,I have a scenario as below1. User will create a form and save it as draft - this record should stay with the originator and should be availble in his work list2. Then when the user click on submit button , the record should change the status to submitted and the workflow should go to his manager for approval.To address this:I have created 2 work flows in Designer1. when the user click on save as draft button2. when the user click on save and submit button The issue is1. Is there a way to combine into 1 workflow2 . If I maintain 2 workflow for a single form, only one is active . And if i need to make the other workflow active , i need to manually deploy the 2nd workflow ........(the other becomes inactive) Appreciate your inputs..ThanksMani  

Hi, Anyone else come across this? On my form, I have the calendar control set to show short date and user settings. This displayed todays date as 16/06/2017 (UK format) this is correct. If i then put that Calendar control in the body of an email (In Smartforms Action Send Email), its comes out in like this 2017 - 06 - 16 I even tried transferring the value of the calendar control to a data label and trying various styling options and data type options, wrong changes the appearance when it appears via email.... Please don't tell me this is another bug....

Hi, I am trying to get  worlist using worklist = cnn.OpenWorklist(criteria); The criteria is  to get worklist items with ( (Status=0 or Status=1) and Owner=Me)  or ( Status=0 and Owner=Other).I tried something below.                   criteria.AddFilterField(WCLogical.StartBracket, WCField.None, WCCompare.Equal, null);                    criteria.AddFilterField(WCLogical.StartBracket, WCField.WorklistItemStatus, WCCompare.Equal, 0);                    criteria.AddFilterField(WCLogical.Or, WCField.WorklistItemStatus, WCCompare.Equal, 1);                    criteria.AddFilterField(WCLogical.AndBracket, WCField.WorklistItemOwner, "Me", WCCompare.Equal, WCWorklistItemOwner.Me);                    criteria.AddFilterField(WCLogical.Or, WCField.None, WCCompare.Equal, null);                    criteria.AddFilterField(WCLogical.StartBracket, WCField.WorklistItemOwner, "Other", WCCompare.Equal, WCWorklistItemOwner.Other);                    criteria.AddFilterField(WCLogical.AndBracket, WCField.W

I have created a List in SharePoint and created Forms and views. I have modified the new form design in SharePoint, but it dint reflect for other two forms [ Edit and Display]. Do we have any specific method for changing all the design commonly.  Thanks in advance,

Hello All.  I need some newbie help again. I am working with pulling in records from a table whereby it will use the out of the box AD service types to create AD accounts as well as assign groups. I am trying to figure out how to deal with the innate behavior of Workflows halting immedietely after it fails using the smartobject. For example, below are some snapshots showing in this case my For Each loop processing some records and if I were to use the Ad smart object to create an account and if it already existed it would error and halt. So then I added in calling the GetUserDetails to see if the account is there and try to do some logic to check the length of the email returned and if a value is there I do not need to create the account. However, if the account is not there, it halts immediately. Can someone help direct me to the best approach for exception handling and how to deal with this problem? Thank again for your help!Steve 

Good evening, I've been testing how to deploy/test a custom service broker.  While still fumbling around a bit, I seem to have the basics down.  I am confused about 1 thing at this time.  I admit I am ignorant about how the data is stored - my assumption is that it is in a SQL DB since I don't see any registry entries.  When I try to create a Service Instance from the Service Type I just created, I get an error stating that "ServiceInstance name already exists". I am pretty sure I went about adding and deleting types/instances via this UI a few times with no issues and now this is cropping up.  I'd like to inform the DB owner about my issue and direct him where to look and how to clean up my mess.  Is there a particular table where these values are stored, my assumption is that he can just go in there and delete a row or two.  I don't have direct access to their DB's.

Experts, I have few queries. Currently we are in 4.6.6 and planning to upgrade to 4.7.               - We are planning to setup a new servers, instead of using our old servers. I mean we are planning to install a k2 with 4.7 version in new server and then planning to migrate our all applications from our old server to new server. Is it ok if we go live one application one time or we need to go live all the applications at a time?             - And if we are setting up a new servers, can we generate reports on the old data(Data which exists in 4.6.6 version)?  And also please let us know the challenges which we need to be consider. RegardsAmar

Hi. As mentioned in the title, I have a K2 form with multiple fields comming from SharePoint and I would like to show the descriptions of those fields, similarly to how SharePoint does it, below the field itself. SharePoint fields have a description property and already is storing all the field descriptions so I would prefer to reuse those rather than duplicate them as hardcoded text in the form. Is this supported ootb by K2 Forms? Perhaps there is a control or method I have overlooked. Thanks in advance.

Is possible to get Data Field value back to SmartForm after it was started from SmartForm. Important is that I get value when WorkFlow has been finnished and not whe before it starts. I set in WorkFlow start event in SmartForm, that outcome copies to Form parameter, but value of this Field is before WF start and not equalt to the WF end state.

Hi, I have a K2 installation which links to an AD (called AD1). AD1 has 2 way trust of another AD (called AD2).With this setting, obviously, we are allowing users from AD2 to create a new process through SmartForm.And right now, I am planning to decommission AD2 and migrate the users to AD1. My question is, is there any tool/script to migrate AD2 users to AD1 users in K2?This is to maintain the continuity after the AD2 migration, so the migrated users are able to see its running process and action it accordingly. Thank you for your help in advance. 

I'm using K2 SmartForms 4.7. Hi I wonder if anyone else has this problem. I have a SharePoint list which i'm trying to display on a SmartForm sorted by Title or any number field (just not the ID column) and if there's say 20 items and i'm paging at 10, K2 only returns the first 10 items and then sorts them, not sorts them prior to returning them to the page. So what this means is an alphabetical list of companies returns as follows Page 1: Company A (ID = 1)Company D (ID = 3)Company E (ID = 2) Page 2: Company B (ID = 6)Company C (ID = 4)Company F (ID = 5) So all the first IDs are grabbed from SharePoint and then sorted and displayed. This seems strange and also means we can't trust any sorting using the list views?

I want to search values in Tree Control which is of complex type. Also, complete tree hierarchy should be open (visible) on the basis of values entered for searching. I am not able to find this functionality. Please help me on this. Quick reponse will be highly appreciated.  

Hi  there,    when i try to connect k2 Connect server from visual studio it gives the below error     Could not connect to the remot host api  on [k2.xxx.xxx:8085]-  Check the Connect Server in the microsoft service management environment.     when i add an entry in the hoster header of my machine with the host url [k2.xxx.xxx 10.x.x.x.] and ip..I am able to connect.     Note: we are uisng F5 for internal and external load balancing  Please help       

Hi, I'm using this custom control http://community.k2.com/t5/K2-blackpearl/Multilingual/ba-p/1049It works fine but for literal data labels. I am using them for creating a hyperlink in my text like this:I have read and accepted the <a href="Linktoprivacy....com" target="_blank">privacy policy</a> When using the language control it removes all html tags and leaves me with:I have read and accepted the privacy policy I tried using expressions with the hyperlink operator but it's the same here.Neither worked inserting the html tag back via javascript as the javascript wouldn't be literal as well and removed the <script>></script> tags. so anyway I can use links in my text with the language control? Thanks for you help.

After the process of Cleanning all the existing views, forms, SMOs from the assigned category at K2 designer and SharePoint list had issues in clearing the associated GUIDs from backend tables due to which the deployment process is not successfull and ended.  We cleared up the environment again to overcome the SMO issue and taken package alone for the specific list[contains all views, forms, designer WF’s] from dev. We cleared all views, forms, SMO’s from Tester tool, designer, WF’s from Workspace, checked for any forms/views any references from database. Again we created SMO’s from SharePoint list, verified Smart Object methods, Smart Object associations.During this activity, deployment process went to hung state. All forms, views where checked out to my Id. This caused due to partial deployment process. Even I am not able to see from designer (because K2 takes AAD account to login)to check in the forms & views. We tried to fix the problem by force check-in forms & views from

I have a requirement to create a K2 Process (Workflow) that will run every week and update some data in my Sharepoint list. This workflow once deployed will run everyweek on Sunday and do the designated task. If needed we may change from weekly to monthly if our requirement changes. I have checked some links on the community but still not sure how to do that in K2. We are using the K2 BlackPearl for SharePoint in our case. Any assistance is highly appreciated!! 

Hi, I have designed a workflow with sharepoint 2013 reference since the design was to trigger the workflow when a file is uploaded. Later the design got changed and now there is no need to trigger the workflow when a file is uploaded. Now the problem is that I am not able to remove the sharepoint reference from my workflow. Is there is any way I can remove it?  Regards,Madhu

Project's UI requires separate calendar controls for Date and Time.  I want to combine these two values with my call to the sql database.  User selects the date on the date calendar control and then the time on the Time calendar control, then submits smartform (I know one calendar control can do this, but the end-user require two separate fields on the form. I'm thinking the Date Time Operator (Add Hours) would work, but I don't know where to put it, that is, I've tried to set the values, but I'm getting nulls.  How can I combine the two calendar values to send to one DateTime SQL Server field. Taffy

Hi, My customer is using K2 black pearl 2.0 with InfoPath form in SharePoint platform. We have may set of workflows, smart objects. One of the workflow sending an email with OpenWorkList Item link. When user opens the link the task assigned to that user and locked from other users. But the Open Worklist Item link missing the InfoPath library name in query string. It is very inconsistent. I have checked the configuration, in K2 workflow the value is fetched from WorkListItem Instance(Browser Workflow Context) which contains WorkListItem Link. Can somebody tell me how WorkListItem Link configured, are there any steps available to reconfigure the link. Thanks,K Senthilrajan 

Hi all, Are there any official best practices for rebooting the Blackpearl server? Additionally, is there a best practice to determine server health? If we experience performance degradation in the Designer or Forms, is there a recommended way to fix it, short of rebooting the whole server? Thanks for any insight.

Hi I have created a tester application which involves passing some metadata from the smart form into a workflow. Once the manager approves their task, the values are then passed back into smart form and saved into smart box.The issue is with the approval step as when the user opens an approval form, none of the controls are set.I have attached detailed explanation with screenshots. Please help! ThanksLena

Hello all,We have the following two lists: list A contains a collection of hyperlink items, and list B contains ID from list A and user login - it's one-to-many relationship (i.e. List B may have multiple IDs from List A). Since this link ID in List B was set up as a text column, we ran into an orphan-item situation when a link is deleted from List A. Therefore, we would like to kick off an K2 workflow as follows: when an item in list A is deleted, K2 will look for items in list B by link ID, then delete those items with matching link ID in list B.I created smart objects for lists A and B, and made them available for the K2 site/workflow. However, I didn't find any method to grab items from list B using indexed column (link ID).  There are only three "Get List Item" methods available:  get list item by Name, by ID, or by Title.Help!  Any suggestions will be greatly appreciated.Thanks.

When I worked with K2 for SharePoint 2010, I used the SharePoint V2 Service to create SmartObjects for document sets and content types.  Whenever I created a document set with multiple content types, the SharePoint V2 service would create a SmartObject for the document set and for each content type in the set.  I am now working with K2 for SharePoint 2013.  In my SharePoint 2013 site, I have a document set with content types enabled.  I've "SmartObjectified" the document set using the K2 for SharePoint app.  Although the app created a SharePoint SmartObject for the set, it did not create a SmartObject for each content type.  Additionally, the SmartObject that was created from the document set contains all the fields from all content types.  So, is this behavior by design?  In other words, is it not possible to create a unique SmartObject for each content type in SharePoint 2013?  

I have a listview having dropdownlist controls, which is getting populated from SQL tables. After saving the values for dropdownlist, if again I am going to edit the listview the existing values in dropdownlist is getting cleared. Issue: Save a row in listview> Go to edit mode > The already saved values for the dropdownlists are getting cleared. So whenever I am editing any row ,I have to again select the dropdownlist values! Please help me on this. Thanks.