Forums

ChronoForms v8 is now WordPress ready, ChronoMails is out

The JED needs volunteers!

CF8 - dbread join user id

ChronoForms v8
rb
rbock 1d ago

Is it true that in the DB Read action you cannot use a variable, e.g. {user:id}, in the join?

LEFT JOIN -> X1.BID = X2.BID AND X2.USER = {user:id}

Max_admin
Max_admin 21h ago
Answer

You mean using a variable in the "On" condition ? yes, variables are not supported there but I have added this to the next update

But you can use your condition in the WHERE statement for now, it should work

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
rb
rbock 15h ago

How can I implement this?

In the join, when I manually enter the user ID, I get 41 results.

In the where, I only get 6.

Presumably the entries that exist in both tables.

rb
rbock 15h ago

I think it doesn't work that way, using the Where query. I also wanted to solve this with SQL code, but count and pagination don't work properly. Numerous filters are also in use.

When will the current version be released?

You need to login to be able to post a reply.