...
| Appanvil karma designer | ||||
|---|---|---|---|---|
|
But what can you do if entities are linked with some attributes that are located inside a CSV string or inside XML or JSON? Let`s see.
...
“nrfAssignedRoles” or the direct role assignment. You see here that the user object contains an attribute with value in CSV format and the DN of the role is the first part of this string and is separated with the “#” symbol. So, somehow you need to parse this DN from on one hand, and on another hand, you need to set it as a regular expression. What can be done in this case?
...
You can use “regex” functionality and postprocessing!
...
Let's go back to postprocessing. In this video functions prepared beforehand will be used to transform the strings.
...
The first one will be named “relation_role_fix_to” and with this function, you will get the first substring from this string separated by a hash.
...
The second function will be named “relation_role_fix_ from” and it will create a regular expression that will allow you to find the value you need. Let’s save everything and go back to entities.
...
From the snapshot side, you will need to use “term” because you will have DN in a user and it will relate to “relation_role_fix_to.”
...
Let's enable transformation and link the secondary entity by exact datetime.
...
From the role side, you’ll need to update this linkage to “regex” - regular expression - and switch to “relation_role_fix_ from.”
...
Make sure you don't forget to enable transformation.
...
You must also change the name of the attribute because previously you used “nrfMemberOf” and now you will be using “nrfassignedroles.”
...
The same values must be set in two entities.
...
Okay, let's save the changes and check the results. Refresh the page and run the report. Here are the results.
...
Here are the results.
...
You can learn more about the options and possibilities of ACDI Reporting in SKyPRO Academy. Thank you for your attention and take care.
Should you have any questions or require any assistance, please do not hesitate to contact us at any time swsupport.skypro@skypro.ch