K2 blackpearl

I am building an application tracker and one of the requirements is to have a report that A) reports the number of application this week and B) the number of applcations made the previous week. In addition these have to be reported as a percentage of total applications. Could anybody advise what the best to achieve this Thanks Andrew 

I'm trying to use the contents of a multivalue field in an email, however when sent as plain text the values appear inside XML tags e.g: <collection><object><fields><field><value>MyVar</value></field></fields></object></collection> If I try to send the email as HTML, it doesn't even display in Outlook, no doubt due to these tags. How can I just get the values and strip all the tags?

Hello All, I have a workflow which is only sending email to users (see the attachment). That email has a link for a form which users need to fill. I want to send a email reminder to all the users that end date of form submission is approaching.My question is how can I send a reminder to users with only email activity in workflow? I don't see escalation options in email as we see in user task.Any ideas? 

Hello everybody, I am working to do OutOfOffice using K2 API My Code is the followingWorklistCriteria criteria = new WorklistCriteria();Destinations destination = new Destinations();destination.Add(new Destination(("K2:"+AssignedTo), DestinationType.User)); //e.g. K2:DOMAINUsernameWorkType worktype = new WorkType(AssignedTo, criteria, destination);WorklistShare worklistshare = new WorklistShare();worklistshare.ShareType = ShareType.OOF;worklistshare.WorkTypes.Add(worktype);//Share the worklistktwoWorkflowClientServer.ShareWorkList(worklistshare);//Share the worklist for a managed user//ktwoWorkflowClientServer.ShareWorkList(originator, worklistshare);//When the current user's status is set to OOF the worklist shares defined above will take effectktwoWorkflowClientServer.SetUserStatus(UserStatuses.OOF);return true;  I think this code works fine. The delefate user can see the task of the user that is out of office, but when he want to execute an action from SmartForm it appears the follo

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, I would like to create a Field level audit in my smartform to track form changes in approval state and so on. In my case i dont have an application DB or do not have the liberty to create stored procedures to do audit trail  and i have to manage all this within my smartobject and smartform logics. What is the best way to achieve this in smartform rules and smartobject? One lengthy way to do this is --> Write this rule for all control -- if control on my form changes, call the unbound rule which will create record in my audit smartobject.But this way is cumbersome as i may have more than 200 fields in my smartform and i need to call this rule on all my control changed rules. Any ideas to implement this with least effort? 

Hello, We have a process where the form is routed to approval steps. The approval steps contain a group. All the group members can access the form. Only one member can approve it. The approver can either approve the form via email, worklist on a SharePoint landing page or open the form and click the approve button. When we try to approve the form via SharePoint landing page we are get the following error: "24149 The User properties are not available when the plan option on the activity is set to 'Plan Just Once'." My question is how do you get the user information of the person who approved the form within the workflow? Thank you

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

Hi All, I have a workflow up and running. In one of the view, I have a Check box list  control, which allows multiple selections. I need to change it to single selection. I am wondering what is the best way to do that?  Do I need to change control type? If yes, what will be its impact on form (rules)? Thank you!

Hi I'm wondering is there a way to detect what browser the User has opened the form in?I have a form and as MS Edge does not support K2 if the form is submitted using Edge then part of the data doesn't save. The end user has asked for a notification to be displayed on the form if someone loads it in Edge. Is this possible? Thanks Steph

Hello! I want to use only the first part of the email text. For example, I have the following email: testk2 @ example.com How can I get only the text "testk2"? Thank you!

I have a people picker with more then one user ,when i click submit on the form i want it to create an individual item in the list  for each user in the picker filed? currently it creates one item with all the users.i want an item for each user on to the list.achived this using javascript presave() method but want to know its possiblilty in k2?

Hi All, is there a way to remove some spaces between the radiobutton list values? Thanks

Running from previous versions of Visual Studio / k2 4.6.9   and then upgrading,  we had no problem running K2 with vs2015. Now on a new system with a fresh install,  k2 REFUSES to play ball with 2015 community version.     Is there any reason for this?

Hello everyone, I am currently lookinginto account create processes using blackpearl, AD and Exchange, we have business case wehereby an account needs to be created and temporarily disabled until closer to the new employee's start date. I noticed there were options to disable both an account and a mail box in their respective events, however, there doesn't seem to be options to enable either the account or the mailbox in the same wizards. Is this by design or am I missing something? Thanks in advance  

Hi,  I have to pre-populate user's address from Active Directory on K2 SmartForm. I am using GetUserDetails from AD User SmartObject (Active Directory Service2). Everithing works fine excluding GetUserDetails method does not return Zip with address.  How to retrieve Zip code for the user? I need full user's postal address.   Regards,  Oleg

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? 

Hi, Normally i use a Javascript (Data label + expression) in View and Form tables to change the Table background as follows: <script type="text/javascript">$(document).ready(function() {$("span[name='TableCSS']").closest('table').css({'border':'darkgrey 1px solid', 'background':'#White'});})</script> But I simply cannot get the above to work when the Table in in an Editable List. The Tables above the Editable List have a grey background, I want to change it to white, but the above script will not apply it. I have put the data lable inside the Table and no matter where i place it, the table background remains Grey. As mentioned, same script works on Item Views and Forms, just won't work with List/editable View. I don't want to touch the CSS templates etc and prefer the Javascript method. Any ideas how why it isn't working? Thanks

  Using the answer from the post above; if I have a process escaltion that uses a go to activity outcome, where does the line go? I need this escaltion to kick in at the process level. For me this does not require a line because literally any activity could be hosting the workflow at the time of escaltion. In this instance do I just draw a line from "Start" activity or do I do a line from each activity to the failure activity? Thanks in advance

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();     public TestCustom()     : base("div")     {     }      protected override void OnInit(EventArgs e)     {            Page.Response.Cache.SetCachea

Hi, Just curious, is there a specific way to backup the K2 DB (on local Server K2 DB) using SQL Management Studio, if so what are the steps and what options should be ticked? I am about to install a Fixpack and just want an extra safety net (already have other safety nets), but backing up the DB locally is something i wanna try as well. A step by step guide to create the backup via SQL Management Studio and which options to tick would be great. Thanks

Hi community,  I am facing a situation where i am supposed to migrate users from domain AAA to domain BBB, but instead of changing the domain under K2.Server.Actioner, i accidently created another record. Now i am seeing K2:AAAuser and K2:BBBuser. 1. What is the impact of having both records inside K2.Server.Actioner ? 2. What would happen if K2:AAAuser is updated to K2:BBBuser and there are 2 records of K2:BBB in K2.Server.Actioner?3. Which other tables in K2 database uses the ID from K2.Server.Actioner and would need to update and change those task's ID from K2:AAAuser to K2:BBBuser ?  Thanks!

Hi All,I've run into an issue on our site where users are unable to post comments on our K2 blog posts.  The comment "Submit" button on each of the posts doesn't do anything when selected.  No errors or anything, it just seems like an unclickable image. I've switched to one of the default website themes and tested it but the same thing is happening so the issue doesn't seem to be related to our theme. Here's the blog:  https://www.ecompmarketing.com/seo-blog/ Any ideas or help would be greatly appreciated!

Hello All (Caution Newbie!), I am trying to add 3 columns to a table and to have those 3 columns reflected in my SmartObject for use on a form. I have moddified my table (the easy part!) in the database.In SmartObject Tester app, I refreshed the Service Instance and the new columns are visible in my Table Poperties and List Method. But....The smartobject associated with the table in the ServiceInstance does not return the data from the new columns when I run the "List" method.The new columns are visible in the Properties of my smartobject.But,if I expand out the List method, the new columns are NOT visible in the Properties of the List method. I've clicked on "Refresh SmartObject" on the Smartobject shown in the Tester app, but the new columns do not appear on the List method. Q:  Is there something else that I need to do to get my SmartObject to realize that there are three new propertes in the Servive Instance? Thank you,-tomas 

I've got a List View on a SmartForm, and I don't need headers on the columns because of how my data is set up. I can remove the text label from the headers, but I can't figure out how to get rid of the solid horizontal bar that displays at the top of the View where the headers would go.Is this possible?