search

Bruno17 / MIGX

MIGX for revo 2.2 and above
83 stars 78 forks source link

Multiple 'where' attributes ignored if they're the same #234

Closed jcdm closed 8 years ago

jcdm commented 8 years ago

I created a call to migxLoopCollection with a &where clause that looks like the following: {"name:LIKE":"%para%","AND:name:LIKE":"%hills%","AND:name:LIKE":"%uniting%","AND:name:LIKE":"%church%"}

The issue is that this string is then converted from JSON to an object. This causes a problem because this isn't actually valid JSON. The 'AND:name:LIKE' key is used multiple times and that flattens out the criteria to ignore all but the last value with that key.

This is not an issue exclusive to MIGX, but I report it here because it affects migxLoopCollection.

Bruno17 commented 8 years ago

this is not an issue with MIGX or migxLoopCollection. This is, because an array can't have multiple same arraykeys.

Try to split it in multiple subarrays:

[{"name:LIKE":"%para%"},{"name:LIKE":"%hills%"},{"name:LIKE":"%uniting%"},{"name:LIKE":"%church%"}]