DMXzone Server Connect Support Product Page
Database Table Joins in Database Source Query Builder : Join problem
Reported 8 years ago
2
have this problem
8 years ago 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 8 years ago
8 years ago 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 7 years ago
7 years ago 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 5 years ago
5 years ago Bruce Wilkie replied:
Was this ever fixed?