Identity Manager Community

Forum Create report with two related tables and select column from different table

Create report with two related tables and select column from different table

dnyandev garad extern over 2 years ago

Hi All,

I want to create simple list report out of two table person and ADSAcount.

In where clause I can put join on tables but also want to select columns from both tables in report.

Below is my defination file.

https://1drv.ms/t/s!At2ViqLAc9Hp0maPIVsKfjMbt5WC?e=DBiqK2

When I preview report I get error.

Is it posible to do this if yes then can you help me to get this done.

Kind Regards,

Dnyandev

Parents

0 Markus Weiss-Ehlers over 2 years ago

Simple list reports cannot use data from more than one table. You either need to create a custom read-only view by schema extension in OneIM or use a normal report (DialogReport) that is then made subscribable for your use case.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 dnyandev garad extern over 2 years ago in reply to Markus Weiss-Ehlers

thank you Markus.

I found that if we have foreginkey relation between table then we can pull data from both tables.

Thanky you again and have a nice day.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 dnyandev garad extern over 2 years ago in reply to Markus Weiss-Ehlers

thank you Markus.

I found that if we have foreginkey relation between table then we can pull data from both tables.

Thanky you again and have a nice day.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

No Data