Re: [InHouse] .fullname Options in List field
Hi,
The createdBy. set of fields are pseudo fields generated by the getRecords() function. What it does is look at the createdByUserNum field value, and attempt to find a record with the same num value in the accounts table. If it does, it adds "fields" into the returned record set like createdBy.fullname
I'm actually pretty suprised the createdByUserNum.fullname wouldn't always return an error, since that index should never be created.
It's important to note that this pseudo field is only created when getRecords() is called. If you retrieve the record by any other means (mysql_select() for example), you won't get these values.
You can also turn off these pseudo fields by using the options:
'loadCreatedBy' => false,
in getRecords().
Currently, getRecords only looks in the accounts table, and not in the website membership table. If that type of functionality is required, we could create a simple custom plugin to get that.
Hope this helps clarify. Please let me know if you have any other questions.
Thanks,
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/