Can you do custom joins inside of a dashboard?

[pacificbeavs]

I've built numerous active reports now, and some leverage custom joins created in the report.  I can't seem to find how to do this in a dashboard.  Is it possible?

[MFGF]

I've built numerous active reports now, and some leverage custom joins created in the report.  I can't seem to find how to do this in a dashboard.  Is it possible?

Hi,

You'd need to do the joins in a data module then base the dashboard on this.

Cheers!

MF.

[pacificbeavs]

Sounds good, thanks!

[rodrigorenie]

Hi,

You'd need to do the joins in a data module then base the dashboard on this.

Cheers!

MF.

And how do you create custom joins in data module? Is it possible to create the equivalent to:

Code Select Expand


select * from A
left join B
on A.f1 = B.f1 and A.f2 > B.f2


[bus_pass_man]

Yes, if you have 11.1.4 or higher.  Several different relationship operators were added then.   Previously, there was only an implicit equi-join.

They are =, <  , > , <> , <= , >= , and =N