Joins, Custom Queries and reports

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Posts: 4
Joined: Fri 01 Feb 2013 11:05

Joins, Custom Queries and reports

Post by tsuch » Mon 04 Feb 2013 08:47

I have a table which requires it to be joined to a parent table in order compare it as its business key exists on the parent.

So I can write a custom query to do the comparison and that seems to work well. However, I'd really like this within a report. It doesn't seem like custom queries get written out to the reports.

Is there some better way of doing this, I would imagine that having to compare via a second table to get a business key is a fairly commmon use case?

Should I be using custom queries?

Is there some way get custom queries to appear in the reports?

Devart Team
Posts: 2424
Joined: Fri 24 Jun 2011 14:17

Re: Joins, Custom Queries and reports

Post by alexa » Tue 12 Feb 2013 15:49

Please note that the result of using custom queries is also included into comparison reports just like you work with tables or views. However, if a custom query is specified in the Target section of the 'Custom Queries Mapping' dialog box, then it can't be used in synchronization and the 'Objects marked for synchronization' option can't be selected in the 'Comparison Report' dialog box.

Post Reply