in a Domain, how to define a compound join involving a constant

[paul.maxwell]

I am looking at an embedded JasperServer environment for the first time, and attempting to create a simple domain to understand the end-to-end process.

In the transactional db there is a captions table that carries a foreign key and the table_name relevant to that foreign key. While It is simple enough to add this captions table into the domain, I don't see a way to create a join along these lines:

select *from some_table tinner join captions_table ct on t.id = ct.fk              and ct.table_name = 'SOME_TABLE'   --<< this predicate[/code]

It is that last predicate I don't see a solution for through the UI.

I can of course define a "derived table" but was rather hoping I would not have to do that for every table needing captions.

Jaspersoft Version/Build 6.1_5.1.0.26