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
Hello.   First of all, I would like to say how much I have appreciated the support of this community over the last year in our K2 implementation.  The advice I've received here has been invaluable.   So, here's my next question: I have a simple workflow that fires off a stored procedure in my database which basically runs a query to pull in data fro a specific report.  I want the stored procedure to hit around 2:00am PST when no one is working.  Because the end result of the stored procedure running is about 2500 new records in a specified table with a specified date stamp, it's pretty obvious when it runs and when it doesn't.  So, I created this workflow, and then ran the scheduler to tell it to run.  I am attaching a couple of screenshots...one of the schedule and one of the report that says it's run at least 7 times.   So, in the morning when I go and look at the database table that SHOULD be populated with new records...there are none. HOWEVER...when I then go into the K2 Manageme
Hi, what exactly does the parameter "Database Maximum Decimal Value"?In which cases the parameter has to be adjusted? Andi
Hi Everyone,I have a K2 form with controls that should be visible/hidden based on if current logged in user is part of a sharepoint group. For ex: if the current user is part of "Members" group, he should be able to see "Edit" button a the form.If the current user is just a visitor(Only read permissions) and not part of "Members" group, the "Edit" button should not be visible.For this i tried the following rules: Execute "Get Group" method in "Group" smartobject to get the "GroupID" of "Memebers" group. Then Executed "Is User In Any One Group" method in "Group" smartobject and passing the GroupID from above rule as input mapping and i get "true" or "false". The above works if the logged in user is an admin (Has access to manage permission on sharepoint site).But it doesnt work if the current user is just a visitor as he doesnt have access to verify or access the Sharepoint groups. Form gives an error "Access denied". Can you suggest a workaround for this. (To execute some rules with ad
Hi K2 experts, I am working on a task and stuck on it. Could you please help me out for this. Scenario : I have two dropdowns with names "Question" and "Operator". 'Question' Dropdown is mapped with "Question" SMO. "Operator" Dropdown is mapped with "Operator" SMO. There is no mapping between "Question" and "Operator" table.Now requirement is on particular question, particular 'operator' values should be populated. For Example : if Question is "is this valid", then 'operator' values should be filtered and displayed as "Equal to" , "Not Eqal to". Operator values are as "greater than", "Equal To", "Not Equal to","Less than" etc.So on change of question dropdown, operator values should be filter and popoulated. Please assist me for this. Thanks & Regards,Vivek Â
Hello, I need to create new smart services instance to connect Webservices endpoint How I can connect to AG Webmethods (Gartner’s top SOA product) EndPoint URL Please support  Â
New to K2.I have a workflow set up for document approval. It pulls info from the form, and uses that in the task to ask recipients to approve or deny the attatchments. The workflow kicks off fine, and will email the right group with an email task, but the "click to open worklist item" in the email is showing up blank, with no options in the actions drop down box, and I am not sure why. There are attatched pictures to better illustrate what I am referencing.Â
Hi Experts, There has been a business requirement whereas to prvoide the solution we need to concat the values coming in a dropdown to a label/textbox. I tried using expressions to do that but can not get it working. Any quick help will be highly appreciated. Regards,Gaurav Mehta
Hi,We are trying to filter a worklist web part on the Activity Name to show tasks relevant to a whole department as opposed to an individual, thefilter will not work on the display name of the activity so after a support call with K2, we have been advised to use the 'internal name' of the activity and have been given instructions how to do this. However, the method requires us to input the 'Process ID' and having been through all workflow options in designer and googling, I can't see where the process ID is displayed? I can find the 'Process instance' ID but not the actual process ID Does anyone know where I can find it? Many thanks JulieÂ
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 currentstatus > 20)group by UnitID, GroupIDend elseif @searchtype <> 1beginselect UnitID, GroupID from recon_work_itemswhere currentstatus between 2 and 20group by UnitID, Gr
How can i inject huge JS into SmartForm? Datalabel length limitation is ridiculous.
Hello,I have problem about Save as PDF control on Form K2when i click for print it not show full page (it have space right paper)i setting size is A4 portraitand Form width 100% Thank you
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.  Â
I've searched everywhere for an answer and tried numerous different things but without success so hopefully someone might be able to help. Its already been outlined in a previous Forum post about how to create a single Header View and move it using JScript to appear above Tabs on a  K2 form (http://community.k2.com/t5/K2-blackpearl/Building-a-tabbed-form-with-navigation-bar/td-p/83385) I was wondering if anyone knows if its possible to have multiple Views appear above the Tabs and if yes, could the script be provided?  CheersDan
Hi, I have one SharePoint list where my smartforms open up in full on the page (ie, parent window). I have another SP List where the K2 smartforms are opening into a model window. I haven't actually told either them to do this, but want them to always open in the parent and not the model dialogue box, but can't see where the instruction is coming from as the forms and list settings are the same? Does anyone know where the form or list is picking up the setting thay is telling it how to open the forms? Thanks, hopefully this is something obvous I have missed as usual ;-)
Hi I am trying to find a way to TRIM leading zeros from a number using an Expression in Smartforms, e.g. 00012536 to become 12536 but having no luck - has anyone achieved this?  Thanks in advanceDan
Hi all.I am tring to deploy packege first time after updating to black pearl version 4.7 (4.16060) i recive exeption that unclear to me:System.IO.IOException: I/O error occurred.at SourceCode.ComponentModel.PackageManagerService.ServicePackage.GetStream(Uri itemUri, FileMode mode)at SourceCode.ComponentModel.FileItem.OpenRead()at SourceCode.Runtime.Services.Workflow.WorkflowDeploymentService.Deploy(IDeploymentContext context)at SourceCode.Deployment.Runtime.ServerSession.AsyncDeploy()Â Can you please provide me direction how can I solve this?Thank you in advance
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?
I have a drop down for the submitter to use to select who is next (requirement from the end users). I found the article that explains why the Display Value doesn't continue to be the Displayed Value after the initial selection but I have to find a way to either copy the display value or have the one drop down save both the FQN and the Display Name.  Since this value is then copied into Email Text and used in List View, having the FQN saved is what makes the work - but who wants an email saying hellow to their FQN. I've tried transferring the data to another field, but it only shows up blank. There has to be a solution to this somewhere as I'm finding it hard to believe that others don't have the same issue with end uers wanting to always see the display name.Â
Hi Folks, I'm working on an invoice form right now. The positions are stored in a separate smart-object and use the invoice ID as foreign key.It's necessary for users to select multiple positions and have them passed on to the workflow.It's not (!) necessary for multiple positions to be edited at the same time, I just need the IDs!(I feel this is important to emphasize as I came across multiple discussions on editing multiple list entries.)So far I have tried several things to solve this - with mixed results:1. Multi-select on the list-view through default select by mouse-click. This allows for a multi-select through holding down control, as expected, and returns the IDs just fine.The main issue with this: It is not necessarily intuitive for the users and most importantly not usable on a touchscreen-device.2. Using checkboxes in the List-View. They don't render. From what I've read they are just not available in list-views.3. Combining a list-view with a seperate checkbox-list that's f
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   Â
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).
Hi, I want to remove the duplicate and disabled users from License management.Due to these additional users my license user count is exceeding the limit.kindly suggest me any solution. Thanks in Advance. Regards,Hemant
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.