K2 blackpearl

We have a query regarding k2 performance. The scenario in our project is that we expect around a million process instances( including Active, Completed) created in our system in PROD environment. And at a point we need to query the tasks which are being assigned to a specific user. For this we are relying on the K2 in built “ActivityInstanceDestination” smart object to do a query and find out the tasks that are assigned to a  particular user. We did a sample check and found that for 30k process instances the query to get the tasks assigned to user ( using ActivityInstanceDestination smart object) is taking around 10sec. In PROD this will be degrade the performance more as we will have million process instances.Do you have any inputs or suggestions to handle this particular case, why the ActivityInstanceDestination Smart object query performance is that slower. Is there any way to tweak its performance or is there any other way to get the tasks assigned to a particular user( both Active

list box control changes to data label if i select the data source(procedure)  and then field (eg state) ,please guide ,thanks.

I have view that is smartobject based, one column region id has a drop down list box it has source of stored procedure based smartobject, problem is the region id does not get populated. Please guide, thanks.

Hi All,I have developed a Master/ Details view attached with a SmartForm.Mater contains :YearMonth  Department---------------   -------Jan 2019     Sales Detail Contains:Name      Target($)         Email_id----------     ------------         ------------John        9800             *personal details removed*Smith       4500            *personal details removed*Tony        5000            *personal details removed* My requirement is :After submitting the entry, workflow will be initiated for each salesmen and they will be notified through mail. Thanks with Regards,JD 

I have this problem, I have been able to integrate Topaz Signature Pad to K2 , now  I am trying to save the Base64string i got from a digital signature pad to the database , I have been able to get the string to the Textbox but for a week now , i have been trying to save the string to a database and it still returns null value in the Database column.Looks like this 

hey ,i have download set lanaguage control and create a resource file but still labels and datalabels and textboxes doesnt change to the other language 

Hi,Totally new to K2 & I feel a bit dumb!I quite simpmly cannot get it to work as expected.  I've downloaded & installed the latest release yesterday, imported groups from Joomla, these all being Authors,  given full permissions to the group, created a category, I'm unable to see any 'create new', 'edit existing' etc buttons.When I add menu items these don't work either, I get things like this even though the user has permissions.   Are there any builds of K2 that I could try?   So sorry very new to K2, so don't know if I'm just being stupid (I honestly am stuck!)403YOU ARE NOT AUTHORIZED TO VIEW THIS RESOURCEThe page you are looking for was moved, removed, renamed or might never existed.

Hello there,  I was wonderring what are the steps to create a k2 designer user with restriction to certain views froms and folders. I am currently using k2 4.7 My regards. 

Hi all, Within SQL Server, I'm trying to find out which schema and table K2 Studio refers to to grab the auto-incrementing Process Instance ID. Background: I need to find this because there have been occasions where I needed rollback the K2 database to the previous day's backup (due to unexplained DB corruption). Upon the rollback, the Process Instance ID value is also rolled back. This causes issues in our operations because old Process Instance ID values - which are already used in our other, non-corrupted database - reused in new records. Thus, we have multiple smartforms with the same Process Instance ID.  

Im Using the set language control , and i have my resource file all ready and set . all of the controls are changing their language properly so far , but for the Drop Down List ( WaterMark ) , its not changing at all , anyone knows where is the issue in this ? even tho i checked the Set Language Properties , and it has a check box for "WaterMarks" which means that it should be able to change WaterMarks Language properly .  Any help would be great .  very much thanks . 

Hi, I need to export SQL tables with more than 500 records to excel spreadsheet.When the end user clicks on a button, it will export the SQL tables to excel. Can we accomplish this with SQL stored procedure? Any help is really appreciated. Thanks.

Hello,  I am a newbie to K2. Currently,  I am having an issue to integrate k2 with power Bi.The data is coming from SQL server on K2 list view using the smart object. I want to create reports when somebody clicks on the button (or I will add a button with name 'Get power bi reports'), the power Bi reports will be generated. How to get it done? Btw I am using K2 v.4.7Do I need to write a service broker to accomplish this task? Any help can be really appreciated.

Hi, I have a form that uploads documents to a file share. Works lovely.  I'd like to create a log file on the same file share, where information regarding each new upload is appended to a text log file.  Hope some can help. Craig

How to action a workflow task using Jquery or Javascript using REST Services for K2 4.7 

I have a problem i am facing with K2 now,i am using a solution with K2 which can do Digital Signature, Fine and good I works fine.Now i decided to do something here, I have gotten the base64 string into a K2 Textbox control now when i want to send the base64 string to the Database (Which is a smart Object), its not sending the byte (base64 string) to the database Table.Why is this so? Has anyone had this same issue earlier on? Please I do need help here.

I had a scenario where data needed to be passed from each row of a list view somewhere  and perform an operation. It took me a while to figure this out, so I will share this. In this simplified example I will show a message for each row of a list view.     To begin, add a rule to the list view add "For each item in a List View" Condition         Select All rows        Then click (configure)              The first few times I attempted this I was transferring the data label from the Display Row(s)       This is WRONG!       Nothing shows up.         But instead transfer the data from the SmartObject.        When you transfer the data from the SmartObject it transfers one row at a time.      And the data show up where it is sent!             

I have a textbox which i used to point a base64 string, I been able to use the javascript to get the base 64 string now i want to have it to show the image on picturebox control, how do i go about this, kindly let me know.

I have the below code to execute without datafield Need advise to run the same task with datafield [HttpPost, ActionName("ActionCR")]public async Task<JsonResult> ActionCR(int CRID, string SNID, string action){ChangeRequest changeRequest = await db.ChangeRequests.FindAsync(CRID);// post XML to process serviceSystem.Threading.Tasks.Task<HttpResponseMessage> response;System.Net.Http.HttpClientHandler handler = new HttpClientHandler();string K2ServerURL = @"https://k2d.asm.com/K2Services/REST.svc";string worklistTasksEndpointURI = @"/Worklist/Items";handler.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;{using (HttpClient client = new HttpClient(handler)){string resourceAddress = worklistTasksEndpointURI;//if you want to start sync, append ?synchronous=true to the URL;client.BaseAddress = new Uri(K2ServerURL + "/");string actionName = "(" + action + ")";ViewBag.SNID = SNID;string serialNumber = "(" + ViewBag.SNID + ")";string completeTaskURL = K2ServerURL +

Hi, We have k2 workflow scheduled to run every 1 hours. For some reason K2 was not responsive and users were not able to connect to the server. We restarted k2 host service and k2 suddenly started 100 instances at a time within few seconds. Has anyonce experienced this issues before?

I have a Problem with K2 today and I am trying to see if there is about anyone who has had the very same issue.I am trying to make use of a javascript in K2 to point and hold data in one of the controlsThis works fine : document.FORM1.sigRawData.value += obj.imageData;Where FORM1 is the name of the form, sigRawData is the name of the Html control which looks like this in the HTML file <TEXTAREA NAME="sigRawData" ROWS="20" COLS="50">Base64 String: </TEXTAREA>Now You can see, K2 does not have a name control which I can use in the javascript to point and hold Data, Is there a way I can actually do that to show Literal for controls like textboxes, picture Control, etc...Kindly let me know

While i was going through the  below url https://community.k2.com/t5/K2-Blackpearl-Forum-Posts/What-is-the-difference-between-Server-tables-and-Serverlog/td-p/66600 it is mentioned that we should be using K2 server log to capture process instance errors ,but i am not able to find K2 serverlog.Error .May i know the reason ?  should I be using server.Error to track the error logs ?  Help much appreciated  Thanks in advance

Hi, Happy new year everyone!!! Just started getting this... Message: Object reference not set to an instance of an object.; ServiceName: ADService2; ServiceGuid: 83ac8763-ab*personal details removed*f*personal details removed*bc8-9bde8729b735; InnerExceptionMessage: ; Using the tester tool if i use the getusersbygroup method, then execure, the results are fine, however if i add a filter on department = "a value" then it fails with the above error.... It also fails on the form process, so i guess if the test tool doesn't like it, then theres a problem... I tested on a different server and the Result with filter works fine.... Any ideas?

HI All I have created several Smartbox SO which I'm using in my applicationsFor lots of them such as customer master I need to bulk load hundred of rows of data Does anyone have a simple method to populate these smartobjects with data without having to type each row individually?  thanksPaul

How do we disable the Future date from now() in date picker control? We would like to disable the future date from now (), so the user can not select future dates. 

I've just had a new laptop with Windows 10 issued to me. Whilst I had no problem with the K2 Visual Studio add-in, I can now no longer see the horizointal and vertical scroll bars to navigate to a SmartObject method. Horizontally, it lops off halfway through the method column and vertically, only four methods are shown. So i cannot get down to anymore methods unless I use my arrow keys in conjunction with the properties pane. Really irritating. My monitors, are all set up for 100% font size as they were previously.