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

Hi, I have a smartobject in my K2(4.7) smartbox which will store the file attachments. Now, in addition to that i want to upload these files to a sharepoint 2013. What are all the things required for this requirement?Is K2 for sharepoint must needed for this? 

Hey Folks! We had a very disturbing issue on our Production server which killed our business systems for a fixed interval everyday. Business was unable to compile thier work during this time and every user was complaining. The Server CPU utilization would spike to 80% and more and remain constant the entire interval of almost an hour. We investigatied on what was causing all this by using performance monitors and SQL Profilers . And finally the culprit was a group policy which would clear the cache and browsing history on every users machine exactly at a ascheduled time, which would trigger enourmous number of request on the DB Servers for SharePoint and K2 applications. This in turn choked the servers CPU utilization. Thanks 

Hello All, I am a newbie to K2. I have created a separate smartobject from SQL table for users. I want a certain tab to b visible to all the users in the list. Please could you let me know how to achieve this? Many thanks, Regards, S

I have a requirement where users submit support tickets via email (helpdesk@abcde.com). Is there a way K2 can get that information and create a new item in smart object?

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 cur

I've got a Boolean that when true I want to update the Folio, but I can't seem to get the conversion right. In 4.7 I was able to use an "IF" condition within the context browser which doesn't seem available in 5+. This works in SQL, but not within the context browser. I'm assuming its because the Boolean conversion. select replace(replace(recommendChangeOfRank, '1', 'Promotion'), '0', 'No Promotion')from <table> Essentially if my boolean is 1 I want to append Promotion to the Folio else No Promotion. Any ideas? I've tried the following with different conversion attempts for the change of rank boolean return. (Note in the To String within the first replace I have another string for False) Some I have just place "True" "False" in the Find others have converted to string. 

Hi, I have a check box on my page and it displays fine. The text on the Checkbox is too long and cuts off if someone changes the page size or when i save it as a PDF. How do i make the text in the Checkbox CONTROL wrap to the next line? Thanks

1.Is it possible to show files that are stored file system on Windows on Smartform using "Content" control?2. Is it possible to store attachment files in a directory on file syste? Requirement is, scanned PDFs will be stored on a windows server. I need to show them on Smartform. Another requirement is, user will attach file on Smartform and they should be saved in file system in same directory.Thanks

Hello guys. I have two questions about escalations 1. I know that is possible to redirect a task to another person... but, is there a way to redirect that task to an especific person? What I need to do is that when a person doesn't complete the task, the task should be redirected to the direct boss of the person that the task was send first. Then if the task remains undone by the direct boss, it redirects again to the boss of the new person in charge of that task.  2, Is there a way to create a dashboard to view all the escalated task of a user from all his/her workflows? To be able to see what users have an escalated task from an especific workflow.  And to check if it's the first or the second escalation.  Do you know if there's a simple way to do this?Thanks in advance.Regards!

 Hi all,I know we are in 2017 :) but I'm recently working for an organization that likes things old school and so they still use K2 .NET 2003.Now they finally want to upgrade from K2 .NET 2003 to K2 Blackpearl. And now they want to go all the way...to Blackpearl 4.7.I know its a stretch but is there any tool or way to migrate/convert (totally or partially) the K2 .NET 2003 processes into K2 Blackpearl processes? And how about migrating all process instances that exist in the K2 .NET 2003 database so that they can go into the K2 Blackpearl database? For historic purposes of course. Thanks in advance...     

Hi,we would like to use the SmartObject Service Tester not only on the K2 server but also on a local machine.Is there a way to install the SmartObject Service Tester locally? Thanks in advance. Stephan

I have created custom contol like below. Custom Control Code(TestCustom.cs)using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;//SourceCode.Forms.Controls.Web.SDK.dll, located in the GAC of the smartforms server or in the bin folder of the K2 Designer web siteusing SourceCode.Forms.Controls.Web.SDK;using SourceCode.Forms.Controls.Web.SDK.Attributes;using System.Configuration;using System.Net;using System.IO;using System.Web.UI.HtmlControls;namespace Mpa.Procurement.K2.CustomSmartFormControl.CustomSmartFormServerControl{ [ControlTypeDefinition("Mpa.Procurement.K2.CustomSmartFormControl.CustomSmartFormServerControl.TestCustom_Definition.xml")] public class TestCustom : BaseControl {     private StringBuilder _htmlContent = new StringBuilder();

I have a user that when is viewed on an smart phone squashes everything up in to very narrow colums with very large rows. Is there any way to improve the view.I tried changing the User agent setting but this didn't resolve the problem. Cany any body advise of any other methods Many thanks Andrew

In K2 Studio, how can I specify multiple SP groups to remove permissions? K2 studio allows me to pick only one SP group at a time.. does it mean, if I have five groups to remove, I will have to create five events?  What I am doing wrong? Can someone please try? If you can select multiple grops? We are on version 4.7Thanks,

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

Hi there, I am trying to see if it is possible to achieve the following: I have a view with text boxes A B and C.  I also have two buttons, Button 1 requires that A has a value, Button 2 requires the A B and C all have values. (image 1) I I first click Button 2, then the validation highlighting for all three boxes as expected (image 2).  If I then click Button 1 the highlighting for all three text boxes stay as required, however only the first one actually needs to have a value inserted. (image 3) Is there a way to clear the original validation highlighting from the first Button click? I have tried to work around by calling from Button 1 a seperate "if the view passes validation" rule and setting it to validate a control that always has a value, to make the view pass that initial validation, hoping it would then revalidate, but this didn't clear it either (image 4) Thanks 

I have set up a smartform which populates with users details, Name, telephone, and email when the form is initially opened. Can anybody advise if there is a way that these user details can be automatically saved when the form is first opened. At the the moment it is only saved when the user completes the rest of the form is completed and is saved. Many thanks Andrew

I have a simple workflow (Built in the designer V4.7) which at the moment is either an Approval or Reject outcome. I want to add an other outcome to the workflow - Timed Out. Can any body advise what is the best way to do this.   

Is there a possibility to change filter labels (I mean "Selected Filter" and Quick Search") because I would like to give the Polish name?

I'm stumped on how to trigger or trap an event out of K2. I have a view with a Google Map, the user types in a Lat and Long and I have some custom Javascript which traps the change event and moves a marker on the map to the desired location. The user also has an Autocomplete on my location table. The autocomplete does a Transfer Data to set the same Lat and Long text boxes. The problem is updating a text box with a K2 rule (or any javascript update) doesn't trigger the change event. Is there a way to trigger a custom javascript event on a Transfer Data or similar rule? I tried listening to ajaxComplete but got nothing.

I have create followings views header view  footer view left navigation view view 1 view 2 view 3 And i want to place the above view in the form as per the attached image In the existing out of box smartform layout how can achieve the above. also I tried with table and i cant able to drag and drop the views on the table.anyone help on this.  

I cannot find any option to delete a custom report. All I see is an option to Edit report.Thanks

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 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