Feature Request join tables based on custom list field (JSON array) #786

New Issue

Closed

opened 2021-08-05 14:48:34 +00:00 by TLWebdesign · 0 comments

TLWebdesign commented

2021-08-05 14:48:34 +00:00

(Migrated from github.com)

Steps to reproduce the issue

Create a custom (list) field (multiple true). Use this list field value in dynamic get join view to join a table based on this custom list field.

Expected result

The tables being merged in the $item based on the match between the join table and the data from the custom list field.

Actual result

bool(FALSE)

Additional comments

This happens because the compiler doesn't check for valid JSON. If it would check for valid JSON and then turn it into an array before going further it would add this "Feature".

I've actually did some detective work to find out where in the compiler this was being built and made the necessary changes to the compiler to make this function like it should.

Will do a pull request for it.

### Steps to reproduce the issue Create a custom (list) field (multiple true). Use this list field value in dynamic get join view to join a table based on this custom list field. ### Expected result The tables being merged in the $item based on the match between the join table and the data from the custom list field. ### Actual result bool(FALSE) ### Additional comments This happens because the compiler doesn't check for valid JSON. If it would check for valid JSON and then turn it into an array before going further it would add this "Feature". I've actually did some detective work to find out where in the compiler this was being built and made the necessary changes to the compiler to make this function like it should. Will do a pull request for it.