Dynamic Join Build

Technical support

Moderators: Bob Cergol, Data Access, Cintac

Dynamic Join Build

Postby jldum » Wed Feb 13, 2008 1:53 pm

Hello there,

interesting feature enabling to have more 'general purposes' sql that will generate just the necessary sql for a specific report.
Further I was asking myself whether/why this was limited to 5 tables in the from clause ? What would then be the best practice when I have to select from 8, 9, ..., 15 tables ?

Awaiting a reaction
Regards

Jean-Luc Dumont / Belgium
jldum
 
Posts: 29
Joined: Thu Jan 31, 2008 2:21 pm
Location: Kortrijk

Join Builder

Postby Carsten Sørensen » Fri Feb 15, 2008 5:52 pm

Hi Jean-Luc,

The Joinbuilder is restricted to 7 (not 5) tables. When you use the 5th column 2 additional columns will be available.

In theory no real reason for the limitation - it was originally limited not to overwhelm the user with too many options.

If you need more than 7 objects joined - then you need to use a Dynamic AI SQL View. You can however build the initial join using the joinbuilder and copy the SQL accross to the Dynamic AI SQL View. You can open a joinbuild in one browser tab and a Dynamic AI SQL View in another and copy / paste SQL around like you need.

We might extend the possibility to add more objects to the joinbuilder - however in practice we would expect that you probably would like SUB SQL restrictions (like putting specific WHERE clauses to underlying joined objects) or other more sophisticated SQL that anyway would require the access to FREE SQL.

The disadvantage of the SQL View is however, that it will not be as intelligent as the joinbuilder in terms of only joining relevante tables... However when you join many objects you usually would require more control anyway. (Server edition Dynamic AI does offer some additional rather cool features in that respect (partitioning, free parameters, redirected filters etc.)).
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen


Return to Technical Support

cron