Question

Read Rol of the user from mobile app

14:34 Jul 26, 2021

Hello Community!

I need to read the roles of the user logged in the mobile app. I try with a query sql but I don't have any result (query is working from the sql console). There is any other better option for that?

var sqlText =
			"select u.contactid, u.name, rol.name from  sysUserInRole ur  " +
			"inner join sysadminunit u on ur.sysUserId = u.id inner join " +
			"sysadminunit rol on ur.SysRoleId = rol.id where u.contactid ='" + Terrasoft.CurrentUserInfo.contactId + "'";
		var me = this;
		Terrasoft.Sql.DBExecutor.executeSql({
			sqls: [sqlText],
			success: function(data) {
				if (data.length > 0) {
					var records = data[0].rows;
					for (var i = 0, ln = records.length; i < ln; i++) {
						var sqlData = records.item(i);
 
					}
				}
			}
		});

6 comments

Oleg Drobina

18:26 Jul 26, 2021

Hello Federico,

And have you tried using ESQ select query using the Terrasoft.CurrentUserInfo.contactId as a value for the ESQ filter? Please try this approach as well.

Best regards,

Oscar

Federico Buffa 🧐

18:33 Jul 26, 2021

Oscar Dylan,

Can you give me a example of this query using esq for mobile?

Oleg Drobina

18:44 Jul 26, 2021

Federico Buffa,

I have no example, but the code should be similar to the one below:

var resultArray = [];
var esq = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "SysAdminUnitInRole" });
esq.addColumn("SysAdminUnit");
esq.addColumn("SysAdminUnitRole");
esq.filters.addItem(esq.createColumnFilterWithParameter(3, "SysAdminUnit", Terrasoft.CurrentUserInfo.userId));
esq.filters.addItem(esq.createColumnFilterWithParameter(4, "SysAdminUnitRole", Terrasoft.CurrentUserInfo.userId));
esq.getEntityCollection(function (result) {
	if (result.success &amp;&amp; result.collection.getCount() &gt; 0) {
		var item = result.collection.getByIndex(0);
		resultArray.push(item.get("SysAdminUnitRole"));
	}
}, this);

Best regards,

Oscar

Federico Buffa 🧐

12:41 Jul 29, 2021

Oscar Dylan,

I tried to add the esq query but Im getting error in the filters looks filters not exist in the esq. Im trying to add this in a custom BR. Any idea of the correct syntax?

If I check the esq properties for filters is undefined. As well I tried create a group filter to add it later to the esq but with no luck.

Federico Buffa 🧐

19:51 Aug 05, 2021

Any another idea of how to know the roles of the user in the mobile app?

developer

14:28 Oct 04, 2023

Federico Buffa,

Did you get your answer ?

Show all comments