Generating a list from pieces of other lists

[juuser]

Hmm, seems that Fabrik doesn't like a join from multiselect dbjoin table. It seems to work if you add that databasejoin element in repeat group rendered as regular drop-down. And then add a join from that repeat group to a_clearance table. And "Display mode" has to be "Each row separately". Didn't have time to dig deeper why is this behavior occurring.

 

[bespokeappstt]

No worries. In the end I used sql and created views. Perfect for read only data. Used plotalot to put on front end. I'll leave this open for a a week or so just in case there are any questions.