show all self relation

[david]

In FileMaker, if I have a field with a "1" in every record and I create a relationship matching this field to itself, I can show all the records in a portal in form view.

This technique doesn't seem to work for me in Servoy. All I get is one record showing in the portal. How do I accomplish this in Servoy?

[maarten]

Hi David,

I'm not sure why your selfjoin isn't working, but I always use a stored calc that returns 1.
(if you're using another method, like auto-enter, please let me know)

how to create a stored calc in Servoy:
1) create a column in your table> "numberField"
2) create a calculation using the exact name > "numberField"
NOTES
- if you already have the calc, then just create a column in your table with identical name.
- if Servoy detects identical names, it stores the calc result into the table.
- refresh always takes place when stored calc needs to be displayed.
- you can't perform finds and sorts on unstored calcs.

[Ron]

Creating a selfjoin with a (stored) calculated field works fine.
Just like David I tried to do this with an auto enter value (1), but
it did'nt work.
Can it be done this way, and how?
I found out that auto enter values are stored not only in new records but also in the already existing ones.
Also it seems not possible to change the value, although the property is set to editable.