Displaying data >1 relation away?

Classic Servoy
1

What’s the easiest way to present data from more than one relation away?

I can nest tab panels, but that won’t work in a table, and for one or two fields I end up with all these tiny supplemental forms…

I can create a stored calc, but what’s the hit to overhead?

Scenario (although this is more of a strategy than a tactics question):

I’m displaying a list of Leads. Each lead is related to a person (the caller) who has related addresses and related phone numbers. There’s actually four tables invoved here, but of course looking at a list of leads you might expect to see the main address and phone. I’d like to display that in a table view (among other places).

2

you can “concatenate” relations in order to show data that’s a few tables away and display in for instance a calculation

company_to_orders.orders_to_order_items.quantity

note: not editable.

3

Kewl. That’ll save a lot of ‘carrying up the chain’.

Can that be used in anything other than a calculation, though? Can you place a field on a layout and define it something like that? That would be awesome.

4

you can also use it:

  • inside a label/button.
    (fill the text property)
    -in scripts (setting columns, globals, variables etc…)

note: there’s no clickable GUI in servoy to create these concatenated relations. You have to type them manually.

So bottomline is, you can use them for displaying purposes
but not for manual editing (like in dataproviders)

5

Thanks! That rocks!

(Of course, being able to actually edit across multiple relations would be the best, but even a lowly developer like myself can see that that’s not a cakewalk.)

At least now, for example, if I just want to show a field on a report, I don’t have to create calculations for each field I want to display that’s too far away.

6

Well, thats really cool, I had no idea that this was possible.