DMXzone Server Connect Support Product Page
Database Table Joins in Database Source Query Builder : Join problem
Reported 11 Jun 2016 09:56:52
2
have this problem
11 Jun 2016 09:56:52 User posted:
I define a left join between two DB files, save my action steps and the query doesn't show the correct result.In the Query options of the paged query properties, the join has changed from left to inner.
In the same way, when I change the Offset to a record per page value, in some cases, the value is overwritten by the original value {{_GET.Offset}}.
Thank you for help to get around until the bug is fixed.
Best Regards
Gérard
Replies
Replied 13 Jun 2016 09:06:22
13 Jun 2016 09:06:22 Gerard Bartholome replied:
After I changed the corresponding instructions in the PHP file, the joins works properly, but the join in Action Steps query shows always inner.
Replied 04 Apr 2018 15:36:38
04 Apr 2018 15:36:38 henry Lebers replied:
Hi,
I have the same problem. After creating a paging query containing a left join, the displayed results are multiplied by the corresponding number of items (item photos)
I have the same problem. After creating a paging query containing a left join, the displayed results are multiplied by the corresponding number of items (item photos)
Replied 24 Mar 2020 10:40:16
24 Mar 2020 10:40:16 Bruce Wilkie replied:
Was this ever fixed?