Does hasOne using mySQL limit the list to 10 selections? I have an application which has a list of accounts, each of which has a type, and for some reason my forms can only see the first 10 matching types.
My Model’s init is pretty straightforward, something like
$this->hasOne(‘accountype’’, new AccountType());
Whenever I throw up a form with that field, I get a dropdown box which works just fine – but I can only see the first 10 types.
Oddly enough, if I go behind the scenes and edit the database directly to make one of the accounts use the 11th type, then when I put up a CRUD I can see the record that references the 11th type just fine. I can even hit the edit button and bring up the record, with the 11th type displyed just fine. But if I edit it within the CRUD editor to change the type, even temporarily (without saving the record), I can’t change it back to the 11th type.
So this seems to have something to do with how the DropDown is creating the list of valid selections. I know it’s not the DropDown form field itself, because in other areas I create DropDown lists using \atk4\ui\FormField\DropDown and I have more than 10 selections in them – but I create those lists from foreach loops, rather than a database query.
However, I’m stumped from here – I’m certainly not doing anything intentionally to limit this, but I can’t figure out what part of Agile Toolkit (or anything it uses) is introducing this limit and, then, what do to about it.
Thanks in advance for any help you can give me.