Loop event not passing correctly the parameter to Where condition for read data - works of with php condition

simelas 29 May, 2022
Hello all,

Having a loop with let say three values coming from read database action . data provider is for exemple :{var:read_data_base}

In the body loop another read data action get correctly the first loop parameter into the WHERE condition , and then stay stuck with that value. The loop runs correctly.

If using php condition instead of WHERE condition , parameter pass correctly.

Schematically as follows

READ DATABASE

LOOP

READ DATABASE (stuck with the first parameter of the loop when using WHERE CONDITIONS)
READ DATABASE (Correct if using PHP CONDITIONS)

any thoughts ?
Colnem 29 May, 2022
Hi

I think in this case it's better to use Data Base Table relations if your tables are a common field...
simelas 29 May, 2022
Hi Colnem,

Probably i missexplained.


The problem is a probable a bug as READ DATABASE is meant for the same action which works well when using "PHP conditions" and get stuck when using "WHERE Conditions".

READ DATABASE (remain stuck with the first loop parameter when using WHERE CONDITIONS)
and the same action
READ DATABASE (uses the correct parameter (coming from the loop) when using PHP CONDITIONS)

To my understanding using WHERE Conditions box or PHP Conditions box should give the same outcome for the READ DATABASE (unless i missed something) .....

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

VPS & Email Hosting 20% discount
hostinger