self-relation and search in a aggregation-field

Classic Servoy
1

I have to work with a data base of another (not Servoy) application and extract data! I may not change the tables. Now I have the following problem: in a self-relation (global AT = ART, field VGID = VGID) I count the number in the relation of existing Child data records. Property, it functions so far in such a way! Only in this number field the search (for example: >0) does not function!

What can I do?

2

Aggregation fields are not stored. You need to STORE that number in your database somewhere in order to search on it.

Bob Cusick

3

thanks for the fast answer! in this case I must probably make one woraround, since I may not change anything in the table structures.

4

just use a SQL query to do your “search” - and then you can load the form based on the primary key id.

See the “controller.loadRecords()” SAMPLE CODE.

Hope this helps,

Bob