Servoy Developer Volume II, page 147 and page 155 call for a relationship name within the brackets of “controller.loadRecords()” and “controller.showRecords()”, respectively.
Both of these commands do indeed work but you must follow the documentation exactly, and not be put off by what the Method editor requires.
Bring up the command and then attempt to choose a relationship. It won’t bring the relationship in until you choose a particular field. As it is at this stage, it doesn’t work. With code in place, go back and edit out the field name. Now it does its stuff.
controller.loadRecords(gseven_id$to_security.seven_id) gets entered and validates, but doesn’t work.
Edit to controller.loadRecords(gseven_id$to_security). Now it produces the desired results.
Click controller, scroll to showRecords and double click. This brings in the command “controller.showRecords(Object)”. Double click on “Object” to select it, go find the relationship and double click. Nothing. Single, double and triple clicking produces nothing.
But if you next select one of the data provider fields and double click then the relationship is brought over followed by a . separator, followed by the field. This result is not functional until you go back and take out the field reference.
This is the process I’m referring to.
I’m still relatively new to Servoy, not an expert and still finding my way round both the interface and the documentation. I may not be doing things the way the designers intended. Don’t get me wrong. I’m not complaining, just pointing out unexpected behaviour.
Please let me know what I should be doing. Do you have a page number for the relevant documentation? Appreciated.
Unless we have an issue communicating, propably my mistake, I have adressed what you are talking about. Maybe the attached screen helps. The selected row on the left is the relationship, the selected row on the right is double-clickable…