Hello Mohammad,

You can find the necessary information about the user sessions in System Designer -> System User -> Access Rules tab.

Additionally it can be found in the Audit Log. 

Feel free to build the analytics based on the data from these places.

Lisa

Hi Lisa,

I have enabled Log user sessions management events system setting. but I am still cannot see anything in the audit log once users log off and log in.

Am I enabling the right one, I am using the sales enterprise (cloud). Do I have to contact support for anything to enable the audit..

Kindly direct me since I am lost in this subject..

Thanks for your support,

Mohammad

Dear Mohammad,

It is possible that the settings are cached in Redis. Please contact support at support@bpmonline.com and request the Redis to be flushed. If that doesn't do the trick, write another email providing us with the URL of your instance and if possible temporal credentials to log in so we could check what's going on there.

Lisa

Unfortunately you will not be able to create a field linked to the VwSysRole view in the account object. VwSysRole is not a table. It's a view and it doesn't allow all of the operations that you can do with a table. 

Additionally, account is a unit that is not related to the system roles. Simply, you can't login with an account. Even contacts are not linked to system roles directly. 

Only admin units that you can find in the system section "System users" are linked to roles directly. Basically, when the system decides what permissions you should have, the system looks at the login credentials that you used and it doesn't look at your contact or an account.

Dear Ezequiel,

You can create the filter that would include AND and OR at the same time and would work as described. 

You need to build the filter as shown in the following example:

                var filters = Ext.create("Terrasoft.FilterGroup");
                filters.logicalOperation = this.Terrasoft.LogicalOperatorType.OR;
                filters.addItem(select.createColumnFilterWithParameter(Terrasoft.ComparisonType.START_WITH, "UsrPresents",
                               present.value));
                select.filters = filters;

Lisa

Hi Lisa! 

Thank you for you answer!

sorry, I expressed myself badly, I need to add a filter. The complete filter would be:

Where Id = 'some id' and (name = 'Administrator' OR  name like 'Ope%' or name like 'Supe%')

Can be done?

Regards,

Ezequiel

I show the example below

var esq = Ext.create("Terrasoft.EntitySchemaQuery", {
				rootSchemaName: "SysUserInRole"
});
esq.addColumn("[SysFuncRoleInOrgRole:OrgRole:SysRole].FuncRole.Name", "RolFuncionaAsociado");
var esqFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "SysUser.Id", userId);
var esqFilter2 = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "[SysFuncRoleInOrgRole:OrgRole:SysRole].FuncRole.Name", nombreRol);

The second filter is who should have the OR combination

Regards,

Ezequiel

You can use my example above to create the correct filtration. Just make sure you add all the necessary filters to the collection and then combine them in the way you need. You can use the following example to add the filters to the collection:

// Adding created filters to query collection. 
esqCities.Filters.Add(esqFirstFilter);
esqCities.Filters.Add(esqSecondFilter);

More useful examples can be found in our Academy here - https://academy.bpmonline.com/documents/technic-sdk/7-11/use-entityschemaquery-creation-queries-database.

Lisa

Dear Ezequiel,

Overwriting the method shouldn't impact the access right set for the object as you overwrite it in JS on the user side and the access rights are configured in the back-end in C#.

Please check the functionality again and if there are still some malfunctions provide us with the detailed description of all the actions taken by you and the result you got. You can either answer here, or send the detailed email to support@bpmonline.com so we could take a look. 

Lisa

I have created a Table Sql Server function to get the "master company" of a given company but how can i call it from esq in my client module?

Hi Davyd, how do you identify whether company is parent to your company or not. What parameters do you compare?

Hello there : i have found a way to get the top most account of a given child account (i have created a sqlserver function) but now, i want to execute that sql script from my clientmodule : SELECT * FROM fnGetMasterAccount("<child account id>")



How can i execute it and get the record obtained from ExtJS client module (ESQ?) ?



 

Dear Davyd,

You can find the examples of execution and getting the query results from ESQ in our Academy - https://academy.bpmonline.com/documents/technic-sdk/7-11/use-entityschemaquery-implementation-client.

Lisa

Maybe this example can help

	function getUserSaveRights(callback, renderTo, scope) {
		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);
				callback.call(scope, renderTo, isSysAdmin);
			}
		}, this);
	}

Federico,

Thanks for you help!

I was able to solve the query in the following way:

var esq = Ext.create("Terrasoft.EntitySchemaQuery", {
						rootSchemaName: "SysUserInRole"
					});
esq.addColumn("[SysFuncRoleInOrgRole:OrgRole:SysRole].FuncRole.Name", "RolFuncionaAsociado");
 
var esqFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "SysUser.Id", userId);
var esqFilter2 = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "[SysFuncRoleInOrgRole:OrgRole:SysRole].FuncRole.Name", nombreRol);
esq.filters.add("esqFilter", esqFilter);
esq.filters.add("esqFilter2", esqFilter2);
esq.getEntityCollection(function (result) {
   if (!result.success || result.collection.collection.length == 0) {
		// error processing/logging, for example
		this.showInformationDialog("Data query error");
		return;
   }
   debugger;
   this.set(nombreRol, true);
   return;
}, this);

King Regards!

Ezequiel

Please use the "Boolean" macro. You can find more information in the article by the link below.

https://academy.bpmonline.com/documents/technic-sdk/7-11/basic-macros-m…

Solver using

	{
					"operation": "insert",
					"parentName": "PhotoContainer",
					"propertyName": "items",
					"name": "Photo",
					"values": {
						"getSrcMethod": "getPhotoSrcMethod",
						"onPhotoChange": "onPhotoChange",
						"beforeFileSelected": "beforePhotoFileSelected",
						"readonly": false,
						"generator": "ImageCustomGeneratorV2.generateCustomImageControl"
					}
				},
				{
					"operation": "insert",
					"parentName": "Header",
					"propertyName": "items",
					"name": "Name",
					"values": {
						"layout": {"column": 3, "row": 0, "colSpan": 20},
						"labelWrapConfig": {"classes": {"wrapClassName": ["page-header-label-wrap"]}}
					}
				},

Dear Julio,

You can inspect the Account address detail or Contact address detail for the example of maps realization in the system. 

Also, there is another option - install Field Force package, which contains more complex functionality, and use its possibilities to achieve your goals.

As for now the question is quite complex and general. Please let us know if you will face an issue while implementing the functionality. We will be happy to help.

Regards,

Anastasia

Anastasia Botezat,

Thanks Anastasia, where canm I found this package?, I look for it on marketplace, but didn't found it,

Thanks in advance

Regards

Dear Julio,

Here's the link for the package on our Marketplace - https://marketplace.bpmonline.com/app/bpmonline-field-sales. It is called Field Sales.

Lisa

Thanks, what about the second question? regarding to show info in a tree structure, where each element had associated the same location data structure, like:

1.- "Chile",

1.1.- "Santiago" is on "Chile"

1.1.1.- "Ñuñoa" is on "Santiago"

1.1.1.1.-"Calle Marathon 1000" is on "Ñuñoa"

1.1.1.1.1.- "Building 1" is on "Calle Marathon 1000"

1.1.1.1.2.- "Building 2" and so on are on "Calle Marathon 1000"

Is there some way to implement something like this? for example what https://www.jstree.com/ did. or http://jonmiles.github.io/bootstrap-treeview/,

Dear Julio,

Please take a look at Organizational structure detail in Accounts section. It contains the realization of functionality you need. Please use it as an example.

Regards,

Anastasia

Dear Ezequiel,

The default access rights for the record are distributed while the creation process. In other words, when you change the owner or the created by filed using a business process, the rights won't be re-distributed.

In your case, you just need to add the [Change access rights] element after you change the owner and the author of the record to redistribute the rights to the corresponding users. The more detailed info about this element: https://academy.bpmonline.com/documents/technic-bpms/7-11/change-access-rights-process-item

Best regards,

Lily