Using DAL Queries in Form Builder

Question

Hello, 
 does someone know how to use DAL Queries in Form Builder? 
 Actually I am looking for an example similar as shown in the Documentation , but using Form Builder. I wonder why the Documentation still refers the old forms??? 
 Any input is very appreciable:) 
 Many thanks in advance und best regards, 
 
 Evanela

psundqvist · Accepted Answer

Hi, 
 Either you calculate the display value in a dalCalculatedAttribute on the entity, and then you can set the value like this: function yourSelectField_CustomDefaultValue () {
 IDVault.globalQuery('IDM', '/rest/access/query/global', 'getUsers', ['DALCalculatedAttribute'], { 'department': data.departmentField })
 .then(function (resp) {
 instance.setFieldValue(resp, 'dn', 'DALCalculatedAttribute')
 })
 .catch(function (error) { console.log(error) })
} 
 You could also use the dynamic entity component if you don't need any query parameters. 
 
 Or you can calculate the display value in the form like this: 
 function yourSelectField_CustomDefaultValue () {
 IDVault.globalQuery('IDM', '/rest/access/query/global', 'getUsers', ['FullName', 'userID'], { 'department': data.departmentField })
 .then(function (resp) {
 resp = resp.map(user => ({
 dn: user.dn,
 displayValue: (user.FullName + " - " + user.userID )
 }))
 instance.setFieldValue(resp, 'dn', 'displayValue')
 })
 .catch(function (error) { console.log(error) })
} 
 Best regards, Philip

Nik Vozelj · Answer

Information about form builder is found in Administrator’s Guide to Form Builder but it is still not complete. First you have to setup the query in DAL and deploy it. If it returns some errors when being called later, try flushing the cache on IA. On the form builder you have 2 options: DN Query component or query from code. I rarely use the first one. The code is as follows. Note that if your query has no parameters, do not pass the last parameter at all. Passing empty braces wont work {}. IDVault.globalQuery("IDM", "/rest/access/query/global", "", [], {}) Real example: IDVault.globalQuery("IDM", "/rest/access/query/global", "CheckMail", ["CN"], {"mailToCheck": input, "username": currentUserCN}) .then(result => { console.log(result); }) I hope this answers your question. Best regards, Nik

evanela · Answer

Thanks a lot Philip, 
 this is very helpful, it works 
 Best regards, 
 Evanela

Menu

Identity Manager Discussions

Using DAL Queries in Form Builder

Tags:

Top Replies

Resources