K2 blackpearl

Hi All, I have gone thorugh below URL and I read like Case-sensitive databases are NOT supported. So I was curious to know, is it possible to integrate to case sensitive database from K2 BP? URL: https://help.k2.com/onlinehelp/k2five/icg/5.1/default.htm#Prepare/SCC/SQLServer.htm Regards,Sajna M

The problemI have a problem trying to close a dialog box. Details1. Page /sites/site1/Pages/Dashboard.aspx opens a dialog box using SharePoint Modal API (SP.UI.ModalDialog.showModalDialog)2. The dialog opens the url /sites/site1/Lists/OutputRequests/NewForm.aspx3. K2 redirects the page to https://k2dev.idmdevnet.local/Runtime/Runtime/Form.aspx?_Name=... When the page is successfully submitted or canceled we get "Form submitted successfully" and then the user has to manually close the dialog, which we wanted to be done automatically. - The SharePoint APIs are not longer available since the page is not in the K2 application/domain- window.close and window.parent.close will throw "Scripts may close only the windows that were opened by it."- the close window rule doesn't close the dialog SpecsK2 4.16060.2000.1SharePoint 2013 15.0.4849.1000 Related threads SmartForm rule action "close the browser window" leaves the browser tab open to a blank pagehttp://community.k2.com/t5/K2-blackpearl/Sma

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

Hi K2 Community, Is there any product feature that enables migrate users with all permissions and worklist items related to them (e.g., migrate user A to user B without losing user A's tasks and work items)? I've tried to search information about this topic in the forum, but I only found threads related to user migration between AD domains: https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Migrate-AD-users-to-different-AD/m-p/85952?advanced=false&collapse_discussion=true&q=user%20migration&search_type=thread https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/Migration-script-for-moving-user-to-new-domain/m-p/85821?collapse_discussion=true&page=2&q=user%20migration&search_type=thread And both were answered redirecting them to a Microsoft's guide site. Has been any update since 2016 (the date from the threads I mentioned before) about this topic? Thank you for your help in advance. 

Hello Experts,A requirement to change the color of the field in list view based on Value For example Value selected is Red , the column background need to be Colored red and so on. I did try to use Condition Style , but the color is visible only if i try to edit . any help would be appreciated.MN

Could anybody advise if there is a way to hide the Selected Filter on a list view. Many thanks Andrew  

I have multiple views that are included on a main form.If I run the view separate from the form where all the views reside, the dropdowns populate.If I turn on the main form in run mode and I attempt to open the dropdown there are no choices.

I am using the autocomplete control for our people pickers from SharrePont lists, but when I attach it to the SharePoint Integration People Picker Sourceit has 2 issues, which there doesn't seem to be a fix for                1 - Despite populatin data on initliase it does'nt actually work for a few minutes                2 - When it does start working it omits some names I know exist                3 - (worst bit!) ... it will show a user display name when entering on the 'New form' but when calling back the data                      on a 'edit' or 'display' form, the ID will be returned.  This seems to be a bug that has never been resolved? Instead I used a 'user' smartobject found the management folder on a SharePoint site, this was far more robust than the above one BUT I'm concious that some users won't be stored there if they don;t have access to the site. Solution? ... I tried attaching the 'Active Directory User' smart object but it comes up with an error saying "requires list

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?  

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. Who should be responsible for managing (e.g., creating, deleting, etc.) Service Types and Service Instances? What are your thoughts? How would you define these? Thank you in advance for your time. Brian

Hello! I noticed that even when you specify to not use the thousandths separator on a list view, when making the "Double-click row to edit (default)" option available, when the field is in edit mode, the thousandths separator is present. I've tried all sensable format options (Making the SO property Text Type, using custom formatting on the field etc.) Anyone have any suggestions?  I'm dealing with account numbers in this list, so seeing the "," is not viable when editing a row.  I'd rather not design a subview just to edit a field :P Let me know, thanks!

In my workflow below, in activity Approval, the Destination is set to:Plan per destination: All at onceCreate a slot for each destinationIf I only have 1 destination user, and it selects Reassign or Approve, the workflow correctly moves to Reassign or Approve.If I have 2 destination users, and both destination users selected Approve, the workflow correctly moves to Approve.But, when there are 2 Destination users (for ex: userA and userB), and userA select “Reassign” and userB select “Approve”, the workflow doesn’t move (userA doesn't go to Reassign (Reassign Approver). Is it possible for userA to go to Reassign (Reassign Approver), and after that when userA Approve, then the workflow move to Approve (Get Next Approver Number) for userA and userB ? Thank you. FieFie

Folder C:Users{K2 service account}AppDataLocalTemp has grown to 13GB.  Files in folder look like temp cache files. Can these files be deleted periodically? Thanks

Hi,  I have a simple K2 workflow attached to a SharePoint list that unltimately sends an email.  In a SharePoint Designer workflow you could grab a dynamic 'list item url' from the workflow context options and insert it into the email body text as an auto hyperlink to open the item in display mode.  The fact it was a dynamic url was useful if the list ever moved to a different location so you don;t have to go back to the workflow and change a hard coded URL. Is there a way to do this in my K2 workflow? Or am I right in thinking I would need to create a manual string of the address and insert a workflow 'reference' to the item ID into the string and just use that in the email?  It's something we do a lot, so wanted to make sure I am doing it the most efficient way! Hope this makes sense, Julie

Can someone point me to the documentation on how to restrict permissions to an Editable list view for a SmartObject? I've tried restricting permissions via Management, but the user that is testing can us the editable list URL to edit.  Any advice on what am I doing wrong? Thanks!

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 

Hi there.  I'm wondering when installing CU's do I need to stop traffic to the server to keep end users from using K2 in the given environment.  I have been doing that to be on the safe side, but I'm questioning now whether or not it's necessary.  We use K2 pretty much 24/7 as we have night shift folks as well as day shift, so installing a CU and getting everyone off the server is kind of a hassle.  It seems to deploy just like a package, and I've never had any issues with deploying packages when folks are in the environment. Thoughts? Rob  

Got a few text boxes and text areas on a List View and have added Watermarks to all boxes and set the text to Arial 12 -> The Text Boxes show the watermark in Arial 12 -> The Text Areas show the watermark in tiny Arial 8 (i.e. much smaller) Why is this and how do i get the Text Area Watermark to be Arial 12? If i type in the Text Area, the font is indeed Arial 12, so the problem is the Watermark font size... Bug????

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,

I have to implement a logic to check if a document exists in a document library using a key field. If document exists, update a custom meta data column. But when document doesn't exist, workflow throws error. How to bypass this error if document doesn't exist?Thanks!

Good day. I'm sure I'm doing something really wrong...and this is not the first time it's happened to me....but I'm pulling my hair out. I have a simple workflow that is using the Exchange Mailbox Service custom service broker to go out to a shared mailbox and list all the emails in the box.  Checking the broker in the Smart Object Service Tester, it works perfectly!   So, in my workflow, I start with a create reference event, using the method "List Inbox Emails" Then I use a For Each event to start a process to take each email in the list and write the data to my database using a Smart Object event create method The problem is that when it writes to the Database table, it's putting the data for multiple records in the column of a single record.  So, for example I would expect to see for the first 5 records the Subject column to show: Disclosure statement attachedJuly production numbersTask CompletedOpportunity completedOnsite visit tomorrow Instead I see 5 records with the subject col

Hi everybody, I've installed and configured K2 black perl 4.6.11 then K2 for SharePoint.The app has been deployed to my SharePoint App Catalog then I've installed it in my site. When I've tried to go to the app from my site I configured the K2 URL then I've clicked Next but the redirection finished on error:Could not find the Issuer to use for authentication. For more information see http://k2.com/BXEQPJB I've followed the link but no change... Here is my configuration:     - Windows Server 2012 R2;     - SharePoint Server 2013;     - SQL Server 2014;     - ADFS. Any idea? Kind regards, Kevin LR 

the K2 Designer now errors with:Could not load file or assembly 'K2Field.K2Forms.Controls.Literal' or one of its dependencies. The system cannot find the file specified.

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,In my K2 Application I have created a SmartObject using a sql store procedure, but the SmartObject is not visible in k2 designer workflow.I did check the box where it said "allow it to be used in workflow." but still the SmartObject not visible. Can you assist please?Thank you for your help.