Database query (multiple records) under Library returns null value in Include action

[Quy]

OS info

• Operating System : Windows 10.0.19042
• Wappler Version : 3.7.8

Problem description

Under Library, database query (not database single query) returns null value in Include action.

Steps to reproduce

1. Under Library, create: Database Single Query
2. Under Library, create: Database Query
3. Under API, create: Include Action to step 1 (single record) & Set Value: {{query1.conf_value} returns value
4. Under API, create: Include Action to step 2 (multiple records) & Set Value: {{query2[0].conf_value}} returns null
5. Under API, create: Exec Action to step 2 (multiple records) & Set Value {{exec.query2[0].conf_value}} returns value

[Teodor]

Do you see the query results when you enable the output option, when used with the include?

[Quy]

Output is checked, but no query results.

[Teodor]

What server model are you using?

[Quy]

Server model is PHP.

[Teodor]

Do you see any error when the only step in your server action is the include step?

[Quy]

C:\wamp64\www\wappler\dmxConnectLib\lib\App.php
line 123
“Error parsing the JSON in exec”
“#0 C:\wamp64\www\wappler\dmxConnectLib\lib\App.php(94): lib\App->exec(NULL)\n#1 C:\wamp64\www\wappler\dmxConnect\api\temp.php(8): lib\App->define(‘lib/bar’)\n#2 {main}”

[Teodor]

Thanks, we will check this.

[patrick]

Here an update, replace file in dmxConnectLib/lib.

App.zip (2.1 KB)

[Quy]

Confirmed fix. Thanks!

[Teodor]

This has been fixed in Wappler 3.8.0