K2 blackpearl

We need all the application names which are not registered for the particular Change Request. And we need to send email to respective application groups.  List A CR No App Name CR1 APP1 CR1 APP2 CR1 APP3   List B App Name Email APP1 Email1 APP2 Email2 APP3 Email3 APP4 Email4 APP5 Email5  OUTPUT: Non matching rows for the particular change request from both the list  App Name EMAIL APP4 Email4 APP5 Email5      Note: In SO association we have option to get ONLY matching data.Note :we have access only to the K2 Designer, we dont have access to K2 Studio

Hello everyone,I have been trying to look into installing a couple of tools from the Market, but with everything I try to download I get the following error: An invalid set of parameters has been specified in the url.That happens right after accepting the license agreement when it's supposed to take me to the download page.I have already tried with 3 different browsers so that's an unikely cause.Is anyone having the same issue?

Hello .. I need to known how to create a database with sql server managment..

Im having issues using the version 4.7 to practise the Temporary_Access_Application in  the tutorial for beginners. please i need help on where i can download pervious versions. thanks

Since newer version of BP requires newer verison of OS and SQL Server. Has anyone performed an in-place upgrade from Win2008R2 to Win2012R2?In-place upgrade from SQL 2008 to SQL 2012? And/Or Win2012R2 to Win2016? This is to prep 4.6.11 to 4.7 then eventually to Five.

Good morning, I have been trying to figure out how to access SmartObject data through its Rest exposure, but I have failed with all my attempts.I enabled the endpoints, when I go to the equivalent of this website <https://[server]:8443/SmartObjectServices/endpoints/endpoints.xml> I get a list of all smartobjects and their methods to be used with the Rest Service. But following these instructions https://help.k2.com/onlinehelp/k2blackpearl/devref/current/default.htm#Read.html Only lead me to a "405 Method Not  allowed" errorI have specified the basic authentication, I have added the Content-type header, the documentation does not specify any other headers, and it guides to use the Get method. I figured the Get method is the easiest to test Rest Services so I haven't tried any other ones so far. Has anyone been successful in fixing this issue?

How do I add multiple views in the same view zone?

When Smartform loads in our K2 Black pearl server. we are receiving http 401 error for favicon.ico file load  and it is taking 105 ms of load time. How do we resolve this issue. I have full permissions on K2 standalone farm and db. 

Ok, As a test, I've got a smartobject (smartbox) with a couple of text fields and one guid field with Text as KEY.I then have 1 view and 1 Form I ticked Anonymous access on both the form and view. Opened up the form, entered some data and clicked on SAVE, but yet this error: "Cannot access Smartobject Item 'random guid here' anonymously. Any ideas? The documentation on setting this up is vague....

creating custom javascript control using VS2015 template.custom properties in defination xml   <Prop ID="Link1"  friendlyname="Link 1" type="string" category="Detail" setFunction="VerticalTabs.VerticalTabClientControl.getValue"  refreshdisplay="true"> when I try to get value in js file using the following function(function ($) {//TODO: if necessary, add additional statements to initialize each part of the namespace before your VerticalTabClientControl is called.if (typeof VerticalTabs === "undefined" || VerticalTabs == null) VerticalTabs = {};VerticalTabs.VerticalTabClientControl = {//internal method used to get a handle on the control instance_getInstance: function (id) {//alert("_getInstance(" + id + ")");var control = jQuery('#' + id);if (control.length == 0) {throw 'VerticalTabClientControl '' + id + '' not found';} else {return control[0];}},getValue: function (objInfo) {debuggeralert("getValue() for control " + objInfo.CurrentControlId);var instance = VerticalTabs.VerticalT

How do I make a form control or view float when the main page/form is scrolled?

we have a requirement to join two sharepoint List Smart Object List A & List B Both are having the common column values called "Application Name" how can we create a composite smart objects so that we can have the combination of the List A & List B which are having common application name with out duplication  can anybody help us regarding this requirement?

How do I add a Subview as a subgrid in a K2 Smartform using javascript/jquery?

Hi everyone, Been using ADO Query SMO to convert to excel for a long while, and really like the way it works.One of the MAIN reason why I like the ADO Query to EXCEL is the fact that, it avails me the opportunity to write my query to get specific columns. I came across the CSV Service for getting csv files from SmartObjects. I need to know if the CSV Service can be used to Get Specific Columns from a SmartObject. Would love to have a 'How to Get specific column from the CSV Smartobject', as I have tested the CSV Smartobject, but seem to just get the whole content of my targeted SmartObject returned. Regards All.

 I have created a simple workflow in the K2 designer with a manager either approving or delining a request. However the process owner would like the option of one of two managers being able to either reject of approve the request. So whoever picks up the request can approve / reject it and the other manager cannot repeat the approval / reject action. I have seen this in K2 Studio but can it be done in a workflow created in the K2 designer  

Seems simple enough but, again, I can't seem to figure out.  How to deselect a selected item in a list view via rules.

Hi All, For those that know composite fairly well can I pick your brains? Any advice would be appreciated... Currently; I have a data set returned by a SQL proc and exposed by a smart object.  I want to extend this dataset with an additional item of information that's the result of a .NET library call in a similar manner to how an inline SQL function evaluates for each row returned.  I have the .NET library exposed as a via the custom assembly endpoint. Can a composite smart object provide this inline evaluation functionality? To test this, I've added the additional output property via the smart objects' method bindings, set the services object to the correct function and bound the inputs properties of the function to the relevant smart object properties, however, when debugging via the SOTT the assembly is receiving null input values.  I'm presuming this is because the additional method binding does not have access to the row level properties that have been returned by the main SQL pr

Hi.   I'm using the community service broker for Exchange Mailbox and Exchange Attachments.  While it's not perfect, it does meet most of our needs.   Twice, however, this has happened...we started getting this error:  We have investigated it the Exchange team, and they can't figure out why it happens.  Generally, when the error pops up, it seems to 'fix' itself in *personal details removed* minutes or so.  Yesterday was 45...and i was freaking out the whole time. Strangely, the error happens when ANY of our 3 K2 server instances tries to execute a SmartObject method using that broker.  It's not relegated to a specific service account or server.  One would think of Exchange were throttling K2, it would throttle the specific account, not K2 as a whole. Anyway, does anyone have familiarity with that error?  Any ideas on what we can do to keep it from happening in the future? Rob  

Hi I am digging a bit into K2 database and understand it better.  I know that within the K2 database:1) ServerLog,ActInstDest table holds data about current active processes and user info to whom tasks are assigned.2) K2 updates the above table with new user details when a current user "redirects" its task to another user. However, when a current user "Shares" its task with a new user, K2 does not update the above table and saves this share slot info in another table. In which table within K2 Database does K2 save the user details with whom a current user share its task with? Example:User A has a task to action. User A shares its task with User B. Where does K2 save this "Share" in K2 database? Thanks

Hi, I am able to register the REST service instance using the JSON format attached. But this returns no data when smart object is executed with 200 as response. I have created this JSON using the RESTUNITED.COM. I am using K2 Blackpearl 4.7. Any help or suggestion is much appreciated ThanksAnil

If you are like me you looked all through articles on validating list rows and found some very complicated validation rules that were very hard, actually impossible to put on my submit button. The "for each" and validation rules just did not work My form had 4 separate complex lists and item data as well. Each list had different rules　List 1 had yeso questions and filled in a result column with data only when complete. This list had to have at least 1 row that was valid and every row had to have a value in the result column.　List two just needed at least one row with one column of data all other columns were not required,　List 3 had a bunch of calculations that resulted in values the total of which had to match another part of the form. So the final collume would be greater than zero.　List 4 had to have data in two columns but it was impossible to have data in one and not the other because it went to a sub view that forced that with the save rules　I only describe the lists because you

I have a 8 Level Approval Workflow... have a Buttons View for each Approval withApproveRejectReworkRe-Submit This bring about 16 Different States in the Form and now is very slow... return some loop error that we mitigate increasing the memory. However the form is very slow on Edit.. I wonder if somebody can comment how does a state affect the memory of a K2 Form... surely is not the same to have no states and 10 Views in the From than have 16 States with the same views...  The Browser constantly crashing... =( 

we have a K2 DEV Black Pearl server, however after 16 States about 10 views on the Form everytime when clicking the Admin List with a bunch of dropdowns, the webbrowser Chrome appear with a crash. I wonder if separating this will become more scalable to allow being more stable. Any ideas ????

There have been questions by staff here about when the escalation emails should send when the "time" they should send occur outside of business hours. We have the escalations set for either 1 day or 7 days. We currently have only Saturday and Sunday outside of working hours. Our hours are set from 8am to 5 pm.  If you submit something that should have a one day escalation on Friday at 4 pm, when does that escalation send on Monday (the next working day)? I tried to test this last weekend and it seemed as if hte escalation didn't actually send until 4 pm on Monday. Even if I changed from days to hours, wouldn't the alert still wait until 4 pm on Monday to send?  The requirement I'm getting from staff is for escalation emails to send right at 8 am if it should have sent anytime during Saturday/Sunday. Is that even possible? 

Hello Everyone. We are using the Dynamic Active Directory Service:http://community.k2.com/t5/K2-blackpearl/Dynamic-Active-Directory-Service/ba-p/869 We added many additional fields to allow us to create/update AD records more effectively.  Whats happening then, is our sync to Gmail takes place, trying to add the new aliases but its not parsing the two emails properly as it would if it were on separate lines as shown prior. How do I deal with this issue? Is there a special format or way to pass this so the multi-value field handles it correctly when loading to AD? Thanks for all help.