K2 blackpearl

Hi All. I was hoping someone can help me understand what I am missing here in terms of how the For Each works in Studio. I have attached a document to help visualize and tell my story. I am pulling the records in using the table_id field as my index/reference and only wanting to process the PENDING status records. For each record it then calls the same table list passing in the table_id to return all the other field values, calls the AD smart object to create the Active Directory records with the fields, then sets the STATUS to COMPLETED. It only runs though for the first record. If I remove the filter/input mapping of PENDING it will process all the records as I would expect it too. What am I missing here? Thanks, Steve

We are migrating our K2 (4.5) solution (with Sharepoint) onto a different server. We have a Sharepoint Event Integration process connected to an update event on a calendar item. When we try to trigger this event on our new infrastructure, it's looking for the process on the old server. We have successfully migrated the software and updated all the environment templates/string values. Does this server value only get set when the process is deployed or is the value of the server held somewhere so we can update it to the new one? The Sharepoint Event wizard only makes the Sharepoint settings available.Thank you for any advice.Rachel

Although I've used stored procedures for execute commands against the database, this is the first time I'm using one for a list method.   Basically, I want it to query the data slightly based on whether or not they're searching for completed records (<> 1) or incomple records (=1).   When I try to create the Smart Object, however, it gives me two sets of properties UnitID, GroupID, UnitID(1), GroupID(1).  That doesn't work... Anyway, my SPROC is as follows.  Anyone have any thoughts? Rob    ALTER PROCEDURE [dbo].[Group_aggregated_sproc_2]@Searchtype intASBEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON;-- Insert statements for procedure hereif @searchtype = 1 beginselect UnitID, GroupID from recon_work_itemswhere (currentstatus = 1 or currentstatus > 20)group by UnitID, GroupIDend elseif @searchtype <> 1beginselect UnitID, GroupID from recon_work_itemswhere currentstatus between 2 and 20group by UnitID, Gr

Dear all,I am creating a SMO from a service object using a SAP BAPI.When try to execute the SMO from K2 service tester, it prompt an error:Error filling table for structure ‘XXXX’ .Service: connect service.Anyone come across this error before? Mind to share how to tackle this error?Thank you.

I have a textbox used to search a list view.  However by default hitting Enter on a textbox does nothing.I need to click an existing button when people hit enter while on that search textbox.I tried this JS<script> $('[name="Search Box"]').keyup(function(event) { if (event.keyCode == 13) { $('[name="Refresh"]').click(); } }); </script>("Search Box" being the name of the textbox, and Refresh being the name of the button, however I have tried it several times and the button does not get clicked when I hit enter. I have also tried .keypress instead of .keyup and neither work. The Data label is set to literal) I know this has been asked before but the above was the solution, and it is not working for me.Running K2 4.7Thanks

Hi,I have an issue with date controls in my forms, they are saving as *personal details removed* every time no matter what date it is. If I do a create in the smartobject tester the date creates correctly, however when I do this within my form it saves as *personal details removed*. Even if I leave the date field empty it still saves as this value. I have tried deleting and re-adding the field, changing the format, hard-coding the date, using the current system date and am still getting the same issue. Can anyone advise?Thanks.  

Hello,I need to confirm that, do I need a license to use DocuSign? Br,Mahjooob

Hi All, How to insert hyper link inside a Rich Text control? I tried CTRL+K but it is not working.  Regards,Madhu

Hi, Is there a scripty/data label way of increasing the height of the text area as each new line is reached? I followed this thread: but the height increases each time a character is entered, which ends up with a huge gap at the bottom of the text area.Also, the first solution only works if you click outside of the text area, which is pointless, as the user isn't likely to do that. Is there a way to have the text area add a line to the height each time a new line starts? Thanks

Hi, Anyone able to advise on this. I'm thinking of a List view, where above the view, a user clicks a button to bring up a sub-view where they enter the details of an item. Then they click save and the details will be transfered back to the main form and added to the List. The user should be able to click that button several times to add more items via the sub-view. One of the fields which the user adds info to is lengthy, so when it is transferred back to the list view, because the list view shows each record per line, it will chop off the text of this one field because of its length. Is there a way of showing all the text, is a column view rather than a list view for each item that is added? Hope that makes sense.

Hello, I am seeking help on following. Let me explain you the scenario. I have created Smartbox SMO which contains details about Leave Year, Alloted leaves, Balance leaves and Availed leaves. Based on this SMO I created 02 Views as follows. 1. Alloted Leaves List View: This view contains details about Leave Year, Number of leaves and Total leaves etc.2. Availed Leaves List View: This view conatins details about Balance Leaves and Availed leaves. Now when New / Edit form gets loaded - User will select Alloted List View rows and based on this selection I want to display Availed and Balance leaves in another list view. So please can someone help me on this?  ThanksSachin 

Hi, I have a user whose name was updated in active directory and now she receives the 24411 Worklist could not be opened <username> is not allowed to open the worklist item error. I have removed the account from K2 workspace and readded, cleared the cache using 'Force Identity Service Refresh' tool and  tried the below in PowerShell but she is still getting the error. Can someone please advise?  $objUser = New-Object System.Security.Principal.NTAccount "mydomain<new account name>"$objUser.Translate([System.Security.Principal.SecurityIdentifier]) Thanks.

Hello guys! Is there a way to add a button to the form in order to allow the user to see the workflow progress?Here's how I planned to do it: but is there a way to add a button to the form?Thanks in advance.    

Hi All Need some help from the CSS experts out there... Is it possible on the AutoComplete control to change the background colour of returned results.For my example I'm using the 'Lithium' theme and find the autocomplete results clash wih the background colour of the formSee the enclosed file I've tried to find a CSS class to change this but no luck yet Any help appreciated thanksPaul

I have been testing this today, and I have a small form that I am testing sending emails with.First I render a small piece of HTML on a Rich Text Field, and then I transfer the raw HTML to a textarea to analyze it.Something like:<span><br>test1<br>test2<br>test3<br>test4</span>The rendered HTML looks fine, and the code in the textarea look fine. When I email it though and Outlook receives it, every <br> is doubled, so the content is now: <span><br><br>test1<br><br>test2<br><br>test3<br><br>test4</span>which of course renders with an extra line break. At first I thought it was outlook but the more I look into it, it seems that K2 sends it that way. Has anyone had this problem?

Hi, I´ve got  a general question concerning  XML Files. Is there any way in K2 to read or write to a XML File thats saved on the file system.I could not found any OOB solution so my next step would be to develop  custom service broker for interactions with XML Files. Are there any other possible solutions? I didn´t expect that K2 is not able to read or write to the file system of the server. Best regards,Andreas

Hello EveryoneI have a k2 form whiche make the employee able to order PCso let say that an employee want to order a PC , after he send the requesthis manger can't click OK until the form make sure that the warhouse is empty and there is no PC sothe manger can esculate the order to the main warhouse.so if there is PC's in the local warhouse the Order does not pass the manger  as you see in the picture the first view is what the employee want to order .Laptop and DEsktopthe second view is what the local warhouse has right nowso the order can not be accepted unless the Item balance is 0i hope it's clearbest regards 

Does anyone have any suggestions on how to safely/gently remove SharePoint 2010 mode K2 assets from K2? When we migrated to SharePoint 2013 we made a "SharePoint 2010 mode" site for all our K2 stuff due to the use of InfoPath.  We've been gradually moving our workflows off of InfoPath, so now the question is how can we safely remove the 2010 stuff?  To be more specific... 1. How to delete the K2 integrated lists & libraries, and their associated K2 SmartObjects2. How to delete the 2010 site & associated service instance from k23. Finally, how to uninstall the K2 for SharePoint 2010 software installed on our servers In my experience, what I think will work I find out later on k2 support calls were not the recommended approach.  The irony being that I can never find anything outlining the recommended approach LOL Thanks,

I have a list created by a smartobject which is integrated with SP on prem. Once an item has been approved, I want t take certain data elements from that smartobject and added it to a SharePoint Calendar. I have no idea where to start for this last part. I am running version 4.7 at the moment and my SP is 2013

I was wondering if anyone knows of a way to check all active workflows and find which are on a specific workflow activity.e.g. I have a workflow with three activities 1,2,3 and I want to find all active workflows that are currently waiting on activity 2 Is that possible? I suspect there'd be some sort of record in the K2 database but I'm not sure if theres anything I could query

Hi, In certain scenarios, I want to hide multiple contols on a view. Is there a rule to hide multiple controls in one rule? Right now, I am using 'Hide a Control' rule on view. So I have to use 'Hide a Control' rule multiple times to hide multiple controls, and later on I am showing them in different scenarios.   Is there a way to hide/ show multiple controls altogether? 

Hi All,I have 3 textboxes in new form for which I save the data in one SharePoint list field.eg. Textbox1 contains say value T1, Textbox2 contains T2 and Textbox3 contains T3, then I save the data as T1;T2;T3 in my list field. Now, I need to segregate the data in Display/Edit forms based on semicolon acting as separator. I have applied expressions for all 3. These expressions work fine when I provide value for all 3 but tend to fail in case I provide T1 as blank.(PFA) Please let me know in case this functionality can be achieved directly(although no split function available in Designer's operators) or some modification in my expressions might do the trick. Thanks in advance,Kamal

I'm building a registration form with some checks while the form initializes, so I had a semi elaborate bunch of "if conditions" "else", but everything was executing as expected, except the disable the form. So I disabled the whole content of the rule and just threw in a "Disable the form" when the form is initializing, and not even that works.Please refer to the Rule.png for the rule composition, and refer to the Form_rendered.png for the form after opening.The form should disable itself right away, but it does not, it stays enabled. Could anyone give me an idea of why it's not disabling? Thank you

Has anyone ever tried to click an attachment control in the background?I'm finding it very difficult. Normally, if it was just a button, a simple jquery that looks like this would do the trick: $('[name="ButtonName"]').click();however, apparently the File control isn't just a button, it's DIV with a table, rows, a label. I've tried making Javascript click all sorts of elements within the file attachment control but it doesn't seem to trigger the file download.I have attached the screenshot that shows what a file attachment control is made up of.If anyone has any ideas I'd love to hear them, thank you!!

I would like to be able to open a file from network locationi know you can navigate to url for a websiteis it possible to navigate to file urifile://network/file.txt this doesn't work in the navigate to url ruleis there another way?