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);
}
}
}
});
Like
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
Oscar Dylan,
Can you give me a example of this query using esq for mobile?
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 && result.collection.getCount() > 0) {
var item = result.collection.getByIndex(0);
resultArray.push(item.get("SysAdminUnitRole"));
}
}, this);Best regards,
Oscar
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.
Any another idea of how to know the roles of the user in the mobile app?
