Is 2 level deep relation search supported?

Classic Servoy
1

Is this suported in a form base on table A?

controller.find()
A_to_B.B_to_C.myfield = 'something'
controller.search()

Doesn’t work in Servoy 2.2, all the records in the table are returned. Looking at the Admin Pages in Database Performance Stats I see that no query has been fired to the DB.

2

Hi Nicola,

That is indeed not supported.
The work around is to use your own SQL as also discussed in the following thread:
http://forum.servoy.com/viewtopic.php?t=7768

Hope this helps.

3

ROCLASI:
Hi Nicola,

That is indeed not supported.
The work around is to use your own SQL as also discussed in the following thread:
http://forum.servoy.com/viewtopic.php?t=7768

Hope this helps.

Thanks Robert, I will use a query or maybe a view, the form is just a list to select records from so a view would be perfect for this.

4

Hi Nicola,

Searching over relations over multiple levels (including self-joins) will be one of the new features supported in Servoy 3.5.

Rob

5

Wonderful news!
This will certainly make my (and I am sure a lot of others) life a LOT easier.
I had to recreate a LOT of Servoy functionality just to get past this limitation. No more! :)

6

Good news indeed!

7

THIS is wonderfull news!

is the search also enhanced, so that we can set the search in a special mode, that this: ‘#%…%’ is inserted automaticly for text-fields?

(the Filemaker-way?)