Virtual workshop: Build your first AI-ready process
Find resources, discussions, and troubleshooting tips to design and manage workflows and business applications with K2 blackpearl.
Recently active
Dear K2, Does SharePoint Content service broker Impersonation work on SharePoint 2013 sites? FYI, SharePoint Service V2 service broker impersonation works on SharePoint 2010 sites in our environment. Thanks.
Hi, I would like to find the "seconds" difference between 2 DateTime values. I am able to do it in the smartform using the "Date/Time Difference" operator. But when i try to do the same in Workflow in K2 studio, i dont find this operators options. Is something am i missing here? TIAAnand
Hi, Anyone know how to edit a list view that just sticks on the Green spinner trying to edit it? I added a script to a Data label on the view and since then the view will no open when i click edit. I can do Checkout, Check-in, but cannot edit it? I tried doing a SAVE AS, but that view also sticks. Any way of getting into it?
When the user of a form completes a form, we would like to send the user a link to the form he has just submitted. Can we do this with K2 Designer 4.7 outside of using the workflow? We can imbed a hyperlink to a form using HTML, but I do not see where we have Sequence_ID to specify the form the user filled out. Is there anything in context browser to build a link? We do not use K2 Studio, and we do not use the workflow currently. If this is possible, I would need some steps to follow. Thanks!
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?
Hi guysI have a procedure that return start date and end date as follows: create procedure [GetWeekdays](@Date Date)AsAsDeclare @Fri datetime, @Mon datetimeset @Fri=(SELECT DATEADD(d, 6- DATEPART(dw, @Date), @Date))set @Mon= (SELECT DATEADD(wk, DATEDIFF(wk,0,@Date), 0) MondayOfCurrentWeek)DECLARE @StartDate DATE = @Mon, @EndDate DATE = @FriSELECT date FROM ( SELECT DATE = DATEADD(DAY, rn - 1, @StartDate) FROM (SELECT TOP (DATEDIFF(DAY, @StartDate, DATEADD(DAY,1,@EndDate)))rn = ROW_NUMBER() OVER (ORDER BY s1.[object_id])FROM sys.all_objects AS s1CROSS JOIN sys.all_objects AS s2ORDER BY s1.[object_id] ) AS x ) AS y inputed: 2017/12/04Results:2017/12/042017/12/052017/12/062017/12/072017/12/08 How can I implement this procedure in such a way that when I press the Button from a Itemview a subview show up with this results. TIA.
I have a list view where instructors click the add list view button to add a new student. The student comes into a dropdown and the entry normally works fine. If the instructor doesn't add someone, but instead clicks on the add new row button twice, I get a blank row. My question is: How do I best prevent the blank row problem. I was thinking of adding a color to the blank row, but I am getting confused in add/edit row values and display row values. I would like to add some sort of conditional formatting on the field, so the blank rows show up with some color, and the other rows with values are normal. The blank rows which are added are very, very tiny and hard to see on the form. I can skip them when I go to write out valid data to the smartbox object, but it still leaves blank rows on the screen if I run a validation, and they are so hard to see. Suggestions? I don't want remote services, but trying to find an example of building this routine. Thanks! BKlaege
Here is the scenario, when an approver denies or approves a list item, I need to save approver's user ID or Name in a custom field in SharePoint list. SharePoint list has "Modified By " field but when K2 Workflow updates an item, this field has default K2 user and not the actual user ID. So I can not use "Modified By " field and I need to retain the user ID that last updated the item in a separate field. I am updating list item using "Update List Item" option in K2 Workflow. Thanks,
Hi All, I want to transfer the Data from a Subview to Main Form. I tried with 'Transfer Data' and fails. Please note that, this subview is not a member of Main Form.
Is there a way via API to loop through the proccess in an error state and retry them?
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.
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
Hi, I have a list displaying attached files, but the filenames are tiny. So you would think that i could go into the column and change the BODY font of my choosing, but alas it is Greyed out? Why can't the font be changed on a File column? Thanks
Is there anywhere in the K2 database or reports that capture when a particular task was allocated to a user? I've found good levels of detail on when a task is redirectred, completed, and released but not when it is set to "Open".
Hi All I have a Radio Button List control on a smartform which is being populated by a SmartObjectI'd like to get a count of the number of items populated in the control when it's populated Have tried using a the list count function and others but cant find a way to achieve it. Anybody have a solution? thanksPaul
Hi, what exactly does the parameter "Database Maximum Decimal Value"?In which cases the parameter has to be adjusted? Andi
Hi, I have an editable list where the User can add a row and enter details. 1) The ENTRY boxes and font size are tiny.I have tried to change the Add Row individual column properties to larger font size, but it remains the same... 2) The Headers are also all small, i changed the properties on the Headers, but they do not change either. When editing the Headers, they show larger. But when i save changes and Check-in, the runtime is showing small font Any ideas?
Hi, We have a client which has put the K2 on a Database with Always on high availibilty groups across 2 servers using active passive infrastructure.For the sake of simplicity, lets call these SQL1 and SQL2.Our primary node is always SQL1. This acts as the “Live replica” and all read-write operations are done on it. SQL2 is just on standby and replicating with SQL1 in real-time. In case something happens to SQL1, a failover is automatically triggered and SQL2 now becomes the primary replica. Once the issue with SQL1 is fixed, we usually fail over manually back to SQL1, bringing SQL2 back as a secondary replica. Is this recommended by K2? Will this cause any issues?
Hi all, I have added a datalabel column in listview and applied some very basic html to display checkbox in that column using expression. These checkboxes can be checked and unchecked. But when I click the "Update Services" toolbar button I did not find any easy way to read the values of these checkboxes row by row. Kindly guide me how to do that with some sample code.There could be an option for doing that using click event of this checkbox using javascript in expression, assign its checked/unchecked value to the next column's cell. But how to access the current row and next using javascript in expression. I will be grateful for your guidance and help. Thanks and Regars
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!
I have a couple of workflows that have gone in to error. When I investigated it was because user account details were wrong so the workflow couldn't find an email hence the error. I have corrected the account details. Is it possible to get these out of error and launch the workflows again Regards Andrew
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. Thanks,
we have a requirement to send an email with the body of the email to be sent,should contain the Screenshot of the view/ data in the View this should be done through k2 workflow can somebody help me on this
Hi, Is it possible to use PowerBI with an OData service instance connection in K2 Blackpearl 4.7? I cannot seem to make it work or find an OData URL as I am missing the API option under Integration in K2 Management. Thanks!
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.