Page Comparison

• Introduction

• Entities basics

• Entity queries

• Linking entities

• Filters

• Entities in Result Table attributes

• Postprocessing

• Complex linkages and postprocessing

Hello there! In this video, you will learn about entities in ACDI reports, what they mean, how to create reports with entities, as well as how to manage entity filters and display attributes of secondary entities in final reports.

If you need a report that will display values for different objects linked with each other by an attribute like groups and its members, roles and users, role requests, approvers, requester, request, target user, etc., you must add a secondary entity or entities to a report.

...

Let's create a report that will show you data about all roles assigned to a user. This report will be created based on data from the snapshot. In ACDI there is a default Users Report which has only one entity, namely, a user from snapshot.

...

Your custom report will appear on the reports list.

...

You may want to update some tags to use them later for placing the report in an appropriate submenu.

...

The entry in the “DateTime” field remains the same as for the copied entity, as do the entries in the “Entity Index” and “Entity primary key” fields.

...

The next step is to create a link between the two entities.

...

Select here “many” to “one.” Let's save the settings.

...

It’s time to add a few filters for a role. Let’s assume you will want to filter by “CN.”

...

Now you see all users and their information. You will probably want to display information about the roles themselves. Let's then add additional data to the “Role” entity.

...

Go to the “Result Table attributes” where you can remove user attributes you don't want to be displayed and add a new field for entity “Role.”

...

The roles have long descriptions and names with all localizations available. This info can be handled with the help of postprocessing. Let’s create a postprocessing function to enable the postprocessing.

...

Let's give it a name “getLocEng.” Here you have a ready-to-use function that will do the postprocessing for you. Now save the changes in your report and implement them to attributes you want to be processed by this function.

...

So you can see here that the table has a flat view - a row per role and columns for each secondary entity are displayed.

...

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.

...