Dear Fulgen,

See this example to find out how to create a method that watch for changes in some fields. In simple words, you will need creating an attribute, that will have dependencies on needed columns and fires a method. You can see many examples in the configuration like this one:

attributes: {

                    "Status": {

                        "lookupListConfig": {

                            "orders": [{columnPath: "Position"}]

                        },

                        "dependencies": [

                            {

                                "columns": ["Status"],

                                "methodName": "onOrderStatusChanged"

                            }

                        ]

                    },

...

where:

"columns": ["Status"] - list of columns where you watch for changes

"methodName": "onOrderStatusChanged" - method that fires when "Status" column is changed

Dear Fulgen,

I have answered here how to watch for changes in a field. Pressing Enter fires the changing event. If you need more complex logic, you may need to create your own controls. Follow this link to see how.

Dear Ricardo, 



Here is the academy page that will help you to set up such field:

https://academy.bpmonline.com/documents/technic-sdk/7-12/connected-enti…

Best regards, 

Dennis 

Dear Pablo,

Such task can only be achieved by the means of development in the system.

In the Configuration add a replacing schema of FileDetailV2.

In the schema, you need to:

1. Initialize check of the current user, whether he has system administrator role. This is an ESQ method called in init function.

2. Set the result of ESQ to an attribute, so to use it later in the method check.

3. Override basic addColumnLink method and add two checks: section check and system administrator check.

The example of replacing FileDetailV2 schema is displayed below:

define("FileDetailV2", ["ConfigurationConstants"], function(ConfigurationConstants) {
	return {
 
		attributes: {
			"isSysAdmin": {
				"type": Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
				"dataValueType": Terrasoft.DataValueType.BOOLEAN,
				"value": false
			}
		},
 
		methods: {
			init: function() {
				this.getUserRights();
				this.callParent(arguments);
			},
			addColumnLink: function(item, column) {
				if (this.parentEntity.EntityName === "KnowledgeBase") {
					if (this.get("isSysAdmin")) {
						this.callParent(arguments);
					}
				} else {
					this.callParent(arguments);
				}
			},
			getUserRights: function() {
				var scope = this;
 
				var currentUser = Terrasoft.SysValue.CURRENT_USER.value;
				var sysAdmins = ConfigurationConstants.SysAdminUnit.Id.SysAdministrators;
				var esq = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "SysUserInRole" });
				esq.addColumn("SysRole");
				esq.addColumn("SysUser");
				esq.filters.add("SysUser", Terrasoft.createColumnFilterWithParameter(
					Terrasoft.ComparisonType.EQUAL, "SysUser", currentUser));
				esq.filters.add("SysRole", Terrasoft.createColumnFilterWithParameter(
					Terrasoft.ComparisonType.EQUAL, "SysRole", sysAdmins));
				esq.getEntityCollection(function(response) {
					if (response && response.success) {
						var result = response.collection;
						var isSysAdmin = (result.collection.length !== 0);
						scope.set("isSysAdmin", isSysAdmin);
					}
				}, this);
			}
		}
	};
});

Regards,

Anastasia

Hello,

First, you need to set up an integration with  Azure Machine Learning web service in the bpmonline. Please, see the documentation - https://academy.bpmonline.com/documents/administration/7-12/integration…

Then you can call the web service via [Call Web Service] process element in your business process - https://academy.bpmonline.com/documents/technic-bpms/7-12/call-web-serv…

 

Tetiana Markova,

thanks for your reply.

I tried to consume it using as per documentation but have no luck so far.

(1) tried the webservice using Postmand (works)

(2) try using BMOnline with same parameters

2 headers parameters

Key : Authorization

Authorization : Content-Type

1 body parameters

 Json path : $

Data Type : text

is Array : No

Value : <copy from Postman raw body>

but it keep replying response 400

{"error":{"code":"BadArgument","message":"Invalid argument provided.","details":[{"code":"InputMismatchError","target":"input1","message":"Input data does not match input port schema."}]}}

how to fixed this ? am I missing something ?

thanks

Dear Antonius,

I don't see where you call the webservice. Perhaps, you didn't set a value to input1 parameter

Peter Vdovukhin,

Hi Peter,

thank you for your comments.

I called the web service in Business Process 

I'm not sure whether I set the input parameter correctly. the value and format is exactly same from what I used  Postman.

thanks

Hi Antonius,

You should deploy an application on-site, create a web service call and test network via fiddler to see what request is sent to web service. The message you've got means that bpm'online sends a request in a format that differs from that you are expecting. Then you can set up parameters in a such way that will fit to Azure learning standard.

The other option will be creating a script task with calling that webservice from c# code. If you are a developer this is the best way because allows you to do more than built-in web service call.

Peter Vdovukhin,

Hi Peter,

thank you for your comment.

I follow your suggestion by creating a script task.

(1) [in process methods setting menu] add RestSharp name space 

(2) [in script task] construct Json to be put in body parameter:

string json = JsonConvert.SerializeObject(data);

(3) [in script task] use RestClient to call web service and adding the necessary parameters    

var client = new RestClient("https://xxxxx.xx.azureml.net/workspaces/xxxx/services/xxx/execute?api-version=2.0&format=swagger");
	var request = new RestRequest(Method.POST);
	request.AddHeader("Cache-Control", "no-cache");
	request.AddHeader("Content-Type", "application/json");
	request.AddHeader("Authorization", "Bearer FpIlxxxxxxxxxxxx");
	request.AddParameter("undefined",  json , ParameterType.RequestBody);
	IRestResponse response = client.Execute(request);

it works for me.

thanks !

Hello,

As for now there is no possibility to turn off the indexation for the section in the application, but we have a correspondent problem registered in our system and the functionality will be added in 7.12.4 or 7.13.0 version of the application. In one of these versions there will be the possibility to turn the indexation off for the specific section (turn the global search off for the section). We've also informed our R&D team about this request, so to inform them how important this functionality is.

Best regards,

Oscar

Hello!



Technically, this can be implemented because Azure SQL Single Database has the functionality of the MS SQL Server, which is necessary for bpm’online setup. 

However, this deployment was not tested by any developer or client, thus no one can predict how exactly the system will perform: some functionality might not be working correctly. We suggest to choose cloud deployment instead not to spend any resources for database deployment and maintenance.

Dear Danilo,

File limit depends on amount of lines in the file. According to the stated requirements, the maximum number of imported lines in the file should not exceed 50,000. 

This is the amount at which the file is imported without any issues. As a workaround you can import file in parts or you can implement your own import using the web service Data Service or using OData.

As to your third question, please specify what exactly do you mean? Which attachments are you referring to? 

Angela Zigler,

Hi Angela, thanks for your answer. 

Concerning to third question, I am refering to the Notes & Attachments tab in Account/Contact/Lead/Opportunity. Do this have a limit?

Thanks.

Danilo,

It is impossible to import data in attachments and notes using Import from Excel functionality. Import to Attachments cannot be performed because files cannot be imported via Excel and data cannot be imported to Notes since this is a system column.

Angela, Thanks for your message.

I was referring to the actual attached file. No need to covert into data. Does it have a size limitation?

Thanks.

Danilo, indeed there is size limitation for attached files. It is set to 10 MB as a default value but it can be adjusted in [Attachment max size] system settings. There is no MAX value so it is limited by amount of free space in your database. 

Angela Reyes,

THanks, Angela. That helped me a lot...

Hi Ricardo,

In the string field formula enter the following extension after enclosing in brackets. 

([#Read order.First element of the resulting collection.Planned date of completion#]).ToString()

More information in here: https://academy.bpmonline.com/documents/technic-bpms/7-12/process-creat…

Kind regards 

Thanos,

Thank you so much Thanos! 

Could you clarify your business case (what you are trying to do) or give an example/more information on the end result?

If you mean just the values in a lookup: 

I know you can export data that is bound to a lookup within a package. I do not think you can create a different package and then recreate an object within that package to transfer the data connected to said package. You would have to use the same package.

If you mean data from a section (records), excel my friend. Use the excel exporter tool in the Action drop-down.

Hopefully with more information I can help further!