K2 blackpearl

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 

We just upgraded our dev environment to 4.7.   In a workflow, I have an escalation set by reading an SQL DateTime field via a Smart Object.   The escalation is set for 1 hour later than the value in the field.  For example, the value in the field was 4/28/2017 and 13:44:11, but the escalation was set for 4/28/2017 and 14:44:11 (per confirming the Server.ASync table).   Why is the To DateTime function adding an hour? EDIT:  I had to write the time above in a non-datetime format.  K2 community's site redacted sections of it. 

I have a data entry formIt has several text box fields for entryI would like an easy method of validating certain fieldsie Textbox1 can only have a value between 2200 and 2600 the only way i have resolved this is by having a rule on the control changing,and then using an advanced conditionmust be an easier/better method

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,  I am a newbie to k2. I have created a list view that accesses the database through the smart object. There are like 2000 or even more than records in my database. they don't get uploaded on the smart form. Is there any limit on the list view to show the records. How to accomplish this task?

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!

Hi K2 mates, I am getting Method not found error while doing REST API call to start workflow. Need Help. Sharing my  ode below. Kindly advise string BaseK2Uri = @"https://k2d.xxx.com/K2Services/REST.svc";string ProcessStartRestUrl = @"Process/Definitions(globalit_B_Change Request Workflow)/StartInstance";//Build up a XML string to send to rest serviceStringBuilder sb = new StringBuilder();sb.Append(@"<?xml version='1.0' encoding='utf-8'?><w:ProcessInstance xmlns:w='http://schemas.k2.com/worklist/d1' xmlns:p='http://schemas.k2.com/process/d1'");sb.Append(@"FullName='GlobalITChange Request Workflow'");sb.Append(" Folio='" + requestID + "'");sb.Append(" Priority='1'>");// datafieldssb.Append("<p:DataField Name='ID'>" + changeRequest.ID + "</p:DataField>");sb.Append("<p:DataField Name='Change Request ID'>" + requestID + "</p:DataField>");sb.Append("<p:DataField Name='Requestor Name'>" + changeRequest.CreatedBy + "</p:DataField>");sb.Append("&

Hi all, So i've got a list where the user selects a row (the row has 5 fields) I want to then transfer all of those 5 fields into another List, but put all 5 fields in one column and a new line for each of the 5 fields.End result would be all 5 fields in 1 field on the other list. I am using the transfer data rule, and can put the 5 fields into one column, but it's all next to each other. My question is, how do i get each field onto a new line???I tried <br> between the fields and, neither of which work. Basically here is how i want it to look: PICKER LIST - Row 1 (field1, field2, field3, field4, field5 Add New RowTransfer data to this New Row NEW LIST - Row 1 (field1)field1 should look like this Field1Field2Field3Field4Field5 Come on K2ers, whats the magic character for the new line between items so that i can chuck everyone into one Column? Thanks 

Is it possible to increase K2 Studio canvas? If yes, how?Thanks 

when we try to delete any workflow instance in Management Console, we are getting following error for any of the existing versions/workflows ERROR : The item name must be unique. 'ID' exists in the collection Please advice  

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

Hello! I have a SharePoint site with a document library using document sets. The document set consists of relevant metadata/properties. Is it possible to create a K2 SmartForm to edit document set properties and how would I achieve this? 

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!

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.

Hello All,I have a requirement to use a StringTable value in an email (the URL of one of my forms). How to I reference that value from my email?  Is there a function to use? Should the StringTable values be available from the context browser? Similarly, what's the best way to display string table entries on my form? Thanks,-tomas

I created an application using a SmartObject for the data.  Now my manager would like me to change it to store and pull data from a SQL Server table.  Can I create a SQL Server table, then change the SmartObject to an Advanced SmartObject and point to the table?  Or will it cause errors with my views and forms?  I know I would have to change the methods for creating and updating the data. I don't expect any data to transfer from the K2 SmartObject to the new table, I just don't want to have to recreate the entire application.   Thanks for any input. 

Hi Folks, I'm trying to delete all items in a list that fullfil a certain criterion. In my case a specific value in one of the fields.My first choice for this was a for-each-loop.Obviously inside the loop I can not delete the item as it gets all messy with the IDs and skips every second item.(After deleting item 1 it deletes item 2, but due to item 1 missing, the former item 3 has become item 2 - I hope this makes sense) Now I've gone ahead and worked around this by looping through the items and writing their ID in a separate smart-object. In a second loop I go through the second smartobject and delete all items on the main smart-object whose ID is in there.This works but is obviously way suboptimal. Having the second smart-object lingering around in my db is really not pretty.Also it could turn into a perfomance issue as the list of items to delete is never emptied and just keeps piling on and looping through the whole thing.To empty the auxilary smart-object, I'd have to the same thi

Dear all, I have 2 text field, text field A and text field B. Text field A max length 10 chaaracter. Whenever text field A contain up to 10 character, i want the cursor move to text field b automatically. Is there any method can achieve this without using javascript? Currently i using a rule when text field A contain up to 10 character, focus on text field B. However, it will focus only when i click on somewhere on the form. Thank you.

Hi there.   So, I'm in the process of shoring up a workflow to automate it's starting.  In the current state, someone clicks a button on a form every hour and then checks the workflow URL to ensure that the workflow runs properly.  99% of the time it runs without a hitch, but the workflow does execute a database stored procedure as part of the flow, and sometimes the stored procedure fails, thus causing the workflow to fail and stop. What I'm thinking would be logical would be a way to have a line rule from the "Execute Stored Procedure" activity to an "Email" activity that would kick off when the workflow errors at that activity.  Otherwise, the other line would take it to the next activity in the flow.   I'm not seeing a way to do that, however.  Does anyone have any ideas?  The K2 documentation on exception rules does not seem super helpful... Thanks, Rob  

Today i uninstalled version 4.7 from a server in order to perform and make a guide to a customer on a full instalation from scratch for version 5.2. I followed the steps of the following guide on how to uninstall (including all manual cleaning and verification): https://help.k2.com/onlinehelp/k2blackpearl/icg/4.7/default.htm#Maintain/Uninstall.htm After deleting everything i downloaded the K2 5.2 installer in order to install the new version. However when i run the Setup.exe it goes to the "Upgrade current version", and when I go to the next step I only have "K2 for visual studio" available. Therefore I assume this has not been uninstalled correctly. I've spent all day trying to find any register related to K2, even uninstalled Visual Studio. However i haven't been sucessfull. I already opened a ticket in K2 and will update if the problem is solved. In the meantime, anyone has any ideas?

I have a workflow and one of the steps in the worflow is the creation of a PDF from an item view. The workflow works fine the only issue is that the PDF is squeezing the item view into the middle of the page. See the screen shot attached Could any body advise how I get the pdf to use the full page Regards Andrew

I am creating a workflow to automate purchasing approval requests.The approval process with depend on the value being approved, if the originator's approval limit is lower than purchase value, then it will go to manager for approval, the manager will then approve, but in some cases if even the manager approval limit is still not enough, then it will then go to the manager's manager to approve (until it reaches manager with sufficient approval limit). How do I set up this rule so that K2 knows to keep escalating approval process until a manager with sufficient approval limits approves the purchase?Thanks

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,

I have a form and work flow that has been working fine, It now just started presenting the following error message."object refernce not set to an insatnce of an object" see screen shotIt ocures when the submit button is clicked which saves the form data and starts the workflow.I have had a look at the form and cannot see anything obvious. Could anybody advise as to how I resolve the problem. Many thanks Andrew