Retrieving read_data function values without using table or details list

Retrieve specific field values from a CF read_data function without using a table or details list.

Overview

The issue occurs when attempting to access nested array data from the read_data function using incorrect dot notation paths in the get method.
Ensure the PHP action is placed after the read_data action and use the correct dot notation path to access the nested field, such as read_data1.var.Data1.number.

Answered
Connectivity v6
we webbusteruk 20 Feb, 2019
We have a read_data function which retrieves some values from the database.
[read_data1] => Array
(
[log] => Array
(
[0] => SELECT `Data1`.`aid` AS `Data1.aid`, `Data1`.`number` AS `Data1.number` FROM `server_data_test` AS `Data1` WHERE `Data1`.`user_id` = '123' ORDER BY `Data1.aid` DESC;
)

[var] => Array
(
[Data1] => Array
(
[aid] => 394
[number] => 4
)

)

How do we retrieve the field "number" using php?

Tried the following to no avail:
$this->get("read_data1.Data1.number")
$this->get("read_data1.var.Data1.number")
$this->get("read_data1.Data1.var,number")
he healyhatman 20 Feb, 2019
Answer
1 Likes
$this->get("read_data1.Data1.number")
Obviously the PHP action needs to be AFTER the read_data action.
This topic is locked and no more replies can be posted.