K2 blackpearl

Hello Team, We as team working in isolated development environments, each developer have their own development server which contains a K2 development environment; K2, SQL Server, Visual Studio and so on. Visual Studio is where our expertise area and TFS we are using for version control/source control. We have requirement to use TFS for Application Lifecycle Management for K2 SmartForms, which allows us to track requirements, code, issues, fixes, history, WorkItems and so on. Follwoign are our requirements: (1)    Include SmartForms in TFS(2)    Share SmartForms definitions for use in other environments(3)    Track requirements/changes(4)    Maintain history of changes, WorkItems(5)    Build Automation that next stet leads to Test Automation Please advice on above mentioned requiremnts and in summary a way to use SmartForms with TFS(2013).

I have developed a form which uses a conformation message box. If the user click on Cancel I need a panel in the form to close. If the user clicks on OK In need to run a smart objects save. Could any body advise how I could create this rule thanks. Regards Andrw

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 am new to K2. I need to show the appended comments history from list with versioning enabled on the SharePoint Display and Edit form. I need to show who added the new comments and when. On K2 it just shows the msot recent comments data. How can I achieve this requirement?

   Bonjour,    Je cherche a établir une connexion à partir d'un client (SourceCode.Workflow.Client) vers une instance K2.    Le client se trouve sur ma même machine que K2    Dans la string de connexion il est demandé d'entrer le host de K2.    Où puis-je trouver cette valeur?    G essayé     - "localhost" (port 80 et 5252)   - "127.0.0.1" (port 80 et 5252)   - "IP Du Serveur" (port 80 et 5252)   - "k2workspace-xxx.be"  (port 80 et 5252​)    Le message d'erreur m'indique à chaque fois: Unable to resolve address No such host is known.    Toute suggestion sera la bienvenue. Cordialement.Claude

Is there a way via API  to loop through the proccess in an error state and retry them?   

Hello K2 Community - We will be implementing K2 4.7 soon and I am working on pulling together our internal K2 governance. I would greatly appreciate any guidance you would be willing to provide. Maybe I am approaching this wrong but I cannot seem to find anything related to this topic online. Can we change the 8-hour period and what is the impact of doing so? I have in my notes we might be able to change to 4 or even less? Per our initial internal testing, it didn’t require anytime at all for access. After a person was newly added to a group and they could interface with a K2 workflow immediately? What are your thoughts? How would you define these? Thank you in advance for your time. Brian

Hi all, Anyone else have any problems installing the May update? When trying to update, it fails on this error: 1:0: ExecuteSqlScript.Execute: >> Logged Error: Script execute failed: System.Exception: Script execution exception: Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: 'TRY_CONVERT' is not a recognized built-in function name. 1:0: Component.ExecuteTarget: >> Logged Error: Target did not complete successfully: DataPatches693317 + 693502.sql Any ideas?

Anyone got any ideas why this isn't working. Doing a SAVE PDF Method takes about 10 seconds and basically hangs the page before it's generated and i see it in a File attachment. I am ok with the delay, but want to change the button text to "Please wait...", but it won't change the button text until after the PDF is created. In my rule, i clearly have the change button text above the SAVE PDF method, but it's not accpeting it. I've tried creating an unbound rule, changes the sequence in the rules from one after the other to asynchronous, you name it i tried it, still doens't work. Any ideas?

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.

I am developing a user form (version 4.7 ) which has the following requirements: Auto saving the data as the form is being completed; Time out after 20 minutes if there is no activity on the form;and save the ID as a 4 digit number i.e. 1 would be saved as 0001, then 0002, 0003 and so onCould anybody offer any advice on how I could achieve the above on my form Many thanks Andrew

 Hello All, I have requirement to restart active workflow from the beginning when there is a change submitted for a request for which the workflow is already running in progress.Workflow has 3 stages. User must be able to open pending request from view and should be able to restart the workflow anytime by cancelling the existing workflow tasks which are in progress. I want yo know whether there is standard solution available using K2 studio or we need to build a custom solution. Best Regards,Achyut

Hi, is it possible wo write in the K2 Logs from custom code like a custom service broker or a assembly used in custom code event?Does anyone know best practices or any tips for logging in such custom K2 solutions?  Thanks in advance, Andreas

Hi, Trying to use the K2 SourceCode.Workflow.Managagement with filter produces an error "error converting nvarchar to int" - any suggestions? ThanksSteve

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

Hi again. This is getting so frustrating!   In essence, I am using the Exchange Mailbox Custom Service Objects broker to go into exchange, pass in the Email ID and pull out the body of the email for my SmartForm user to read.   When they execute the smart object, about half the time it works perfectly. The other half the time I get and error that reads: Could not load file or assembly 'file:///D:Program Files (x86)K2 blackpearlServiceBrokerK2.ServiceBroker.Custom.ExchangeMailboxService.dll' or one of its dependencies. The system cannot find the file specified. Although not perfect, typically when I get the error, I can refresh the form, try the button again and it will work as normal.  It will then work normally UNTIl I refresh the form again, then it will start giving the error UNTIL I refresh the form again.   My private theory is that this is related to the number of times I have installed and uninstalled the broker trying to get it to work.  There are multiple service objects relat

Hi, Has anyone else experienced an issue when starting an activity on a dynamic date? The activity goes into a running state however, the status is still set to 'Waiting'. I'm unable to execute the event within the activity because of this.  Thanks

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 All,I am new in K2 - Workflow.I am creating a very simple workfolw in K2. for that while setting 'Event Notification Settings' of task 'Default Client Activity', i am getting blank  for 'From' column instead of 'From Address'. I would like to know bydefault how to get 'From Address' for From column. Thanks with Regards,JD  

Hello Community,I got an error while filtering data in an editable ListView. First I load a value from a different SO. Afterwards I execute the GetList-method on my view with no input-criteria but with some filters. Most of them work but one filter on an value from an associated SO causes an error. The errormessage on the attached screenshot is in German. The translation is: "Invalid column-name 'Association_...'". Do you guys have an idea why I get this error and how I can get rid of it? Many thanks and best regards,Tim aka. Sparrow

I have a department that want to require all their forms be completed using ALL CAPS. Is there something that I'm missing in the Styles properties o the view to make this happen? Thanks!

We currently support several existing K2 Blackpearl/Smarforms environments.  Each environment has its own set of service accounts that are used to run Windows Services and IIS application pools.  Our security engineering department has asked us if any of these service accounts can be converted to Group Managed Service Accounts (gMSAs).  Does K2 support using these service accounts to run services in K2 Blackpearl 4.7?

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

Me, again. Looking around, I see plenty of references to doing this in Sharepoint, but we don't have K2 integrated with Sharepoint. I'd love to be able to use workflow to move a file from one network location folder to another. So, for example, if a file gets dropped into Folder A, as part of the workflow I'd like it to be moved to Folder B.   It seems as though this should be possible ... but I'm not imagining how to do it. Thoughts on the hypothetical? Rob   

I would like to be able to stack some fields in a list view column.  I.E. have one control above another control within the same column in the same row.  Is this possible?