Can ypu help me understand how to access the data from a “list of records by MySQL” which is being displayed an ITEM Page for use in PHP, if possible.
I would like to use the data from a “list of records by MySQL” query which is being returned/displayed succesfully, but I can’t find the data in my var dumps and I got lost in the fieldtype_items_by_query.php and database class files.. Not sure which array it is in (if any), or if there is a simple way to use the displayed data, but thought it would be worth asking.
I’ve created a php query of the same data to use to resolve the immediate problem I was having, but would still like to know if the data is available in an array to determine how I will use the field in the future. BTW, My “list of records” query was using parent_record_id on a child record of “User” entity as a heading field and I thought it was very cool that it returned the user name (inner join) opposed to the id (which is returned by the queried table via a php query).
Great system!
Thanks
Help Accessing Data from “list of records by MySQL” from ITEM Page
- support
- Site Admin
- Posts: 6221
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Help Accessing Data from “list of records by MySQL” from ITEM Page
The data do not store in filed value. It selected from query. So to use the same data in other source you have to create similar query.