Dear Amanthena,

We do not have any ready examples, however you can achieve such task in following ways.

1. Add a dependency on the field change on client side (page schema). Retrieve the value from the field and pass it on to the web service, which in turn would send this value to the external service. Receive a response and set it to the field in order to render on UI. You can see this article on web service call from client side:

https://academy.bpmonline.com/documents/technic-sdk/7-13/how-call-configuration-services-servicehelper

2. Add a dependency on the field change on client side (page schema). Call business process from the client side. Pass a parameter to the business process, this parameter would be the entered value from the field. In the business process add a web service element, which would proceed service calls and than work with the response. You can also pass the response from the service from business process on to the page like described here:

https://academy.bpmonline.com/documents/technic-sdk/7-13/process-launch-client-module

https://community.bpmonline.com/questions/refresh-page-fields-after-process-runs-update-signal

Though, it is quite complicated task.

In any way, please keep in mind, that you need to watch overall system performance and leave some time between service calls. More information can be found here:

https://codeburst.io/throttling-and-debouncing-in-javascript-b01cad5c8edf

Regards,

Anastasia

Thank you for your reply, Anastasia! The reference material helped. The part where we make a service call from javascript and trap the response is clear. But could you help me figure out the javascript APIs that will help me clear, rebind and render it to a control in the UI. Would a dropdown be the best choice here? What do you suggest?

amanthena,

You can send a message from back end to front end.In case you are calling external service via business process, you can check the example here:

https://community.bpmonline.com/questions/refresh-page-fields-after-process-runs-update-signal

The idea is to use sandbox to send and hear message, after message received you set it to the field with this.set.

Also you can use web sockets to communicate between front end and back end. 

https://academy.bpmonline.com/documents/technic-sdk/7-13/clientmessagebridge-client-side-websocket-message-handler

The field type depends on the data you will be working with. 

Hope you find it helpful

Anastasia

The data is a list of key-value pairs, "value" is the user friendly description and "key" is the id that needs to be persisted in the database on selection. i figured a dropdown would be the best control for this purpose. Can we programatically reset the contents of the dropdown in javascript with the data that is returned from the server? Could you tell me how "this.set" needs to be used here?



Once again, thanks for all the help! Much appreciated!

amanthena,

To set value to a lookup (dropdown), you need to pass an object with at least to parameters displayValue and value :

this.set("Country", {value: "a570b005-e8bb-df11-b00f-001d60e938c6", displayValue: "Australia"});

Regards,

Anastasia

Thank you, Anastasia! That helps. I might also need to rebind the list of items available for selection in the dropdown from the data that is returned from the API, and not just the selected item. How do I do that?

amanthena,

Lets say you have a dropdown, which is a Country lookup, when user enters a country name you launch a web service call that returns some internal code for the country. You work with currently chosen country, but want to change others too. You can run an ESQ to the Country object when setting data for current one. When collection is returned from ESQ, you can modify it with values received from web service call.

Regards,

Anasatsia

Thank you, Anastasia! I will explore this further.

Just found the solution to this problem in the following thread:

https://community.bpmonline.com/questions/lookup-field-filter

Javier Collazo,

You can also take a look at this chunk of code, it also represents the combination of two filter groups. The idea is to make firstly one filter group for OR clause. Afterwards, you create a second filter group, which combines a first one OR and other clause. By default filters are added via AND.

getCurrentUserAndTypesFilter: function() {

   var filterGroup = new this.Terrasoft.createFilterGroup();

   filterGroup.logicalOperation = this.Terrasoft.LogicalOperatorType.OR;

   var innerFilterGroupCreatedBy = new this.Terrasoft.createFilterGroup();

   innerFilterGroupCreatedBy.add("CurrentUser", this.Terrasoft.createColumnFilterWithParameter(

      this.Terrasoft.ComparisonType.EQUAL, "Tag.CreatedBy",this.Terrasoft.SysValue.CURRENT_USER_CONTACT.value));

   innerFilterGroupCreatedBy.add("PrivateType", this.Terrasoft.createColumnFilterWithParameter(

      this.Terrasoft.ComparisonType.EQUAL, "Tag.Type", TagConstants.TagType.Private));

   var innerFilterGroupOtherTypes = new this.Terrasoft.createFilterGroup();

   var types = [TagConstants.TagType.Corporate, TagConstants.TagType.Public];

   innerFilterGroupOtherTypes.add("OtherTypes",this.Terrasoft.createColumnInFilterWithParameters(

      "Tag.Type", types));

   filterGroup.addItem(innerFilterGroupCreatedBy);

   filterGroup.addItem(innerFilterGroupOtherTypes);

   return filterGroup;

},

Regards,

Anastasia

Try to create a replacing client module for the page module and modify CSS of the checkboxes according to the article by the link below.

https://community.bpmonline.com/questions/how-add-custom-style-control-page-based-condition

Hello Nuno!



Usually, for changing the appearance of some elements css stylesheets are used.

The idea is to override css rules for the desired elements. I also recommend to use devtools to test css rules in runtime. Article about it: https://developers.google.com/web/tools/chrome-devtools/css/



Also please note on these articles where similar development cases are displayed:



1. https://academy.bpmonline.com/documents/technic-sdk/7-12/advanced-settings-custom-detail-fields?_ga=2.91757139.837207587.1557733380-1226153156.1549047745

2. https://community.bpmonline.com/questions/how-add-custom-style-control-page-based-condition

3. https://community.bpmonline.com/articles/how-add-or-edit-css-style



Best regards,

Alex

Hi,

Basically, merge deletes all duplicate records from DB, so after records are merged they cannot be restored. You can create a backup before merging records to use it later for restoring data. 

Best regards,

Angela

Ah Alright. No worries.

Thanks :)

Hello,

This notification indicates that the process of duplicates search is finished, but there are two possible results: duplicates are found or duplicates are not found. To find out if duplicates were found you can go to "Setup duplicates rules" section of system designer and in "Actions" drop-down choose "Show duplicate contacts/accounts". This action will open the list of duplicated contacts or accounts. Or you can click on "Actions" in accounts or contacts section and click on "Show duplicate accounts/contacts" and it should return the list of duplicates.

Best regards,

Oscar

Oscar Dylan,

Alright!

Also, what does this error imply?

I've been getting this error for last few hours when I run the duplicate search.

aaykay,

This error can be received if there are some issues with duplicates search functionality like incorrect procedure (or errors in it) that is executed when the search is started. It is difficult to say without access to the application in which the issue can be reproduced. Please email us at support@bpmonline.com and provide us with access to the application and we will check it.

Best regards,

Oscar

Hello!

You have two ways how to manage this issue. Firstly, you can create a folder for products, which are in use currently and use not all list of products, but only products from this folder. Or you can set up access rights so that only system administrator has access right to read, edit or delete certain records. In this case, for other users, these products won't be displayed.

Best regards,

Anastasia

It's a very strange idea to stop using multithreading - one of the most powerful JS features. Please make sure that you need this. 

Anyway, details are loading asynchronously and they don't have an "onDetailLoaded" event. One of the latest loading methods will be "onGridDataLoaded" in the BaseGridDetail. Please feel free to use it as an indicator of the fact that a detail was loaded. 

In order to indicate a complete loading of all details please use threading control on a page. Please find more information about threads in the article by the link below.

https://stackoverflow.com/questions/30036/javascript-and-threads

Dear Fulgen,

It seems that this issue is connected with Oracle database structure. I think this article may help you with this issue: http://www.dba-oracle.com/t_ora_01691.htm

Best regards,

Angela

Angela Reyes,

Thanks Angela, we have already fixed the oracle database structure and we can now install package successfully.

We still have issue with our oracle database, we are encountering Oracle error "(ORA-00942) table or view does not exist" on submit case landing page.

We have already done other landing pages before in bpm online instance which uses ms sql database, and the system is working fine. So we are sure we did the same thing the only difference is that this time the bpm online instance is using oracle database. Hope you can help us, solve this issue.

Fulgen Ninofranco,

Have you checked server logs? They might have the information about missing table.