Jaanus
Super Moderator
If a list is created on mysql view then we can see its data both in list and form/details.
But if this data is joined data then we can see it only in list view, not in form/details (not even in readonly mode). Although when looking at the query in fabrikdebug and running it in phpmyadmin then this data from joined view is returned.
I hope it's not too complex to make it possible
If we could work with joined data from mysql view in form view we would be able to create some kind of "ready for filling in" forms. E.g something like intended here: http://fabrikar.com/forums/index.php?threads/how-to-initially-show-repeat-group.32911/
Or if we had some contest with m jury members and n entries then each jury member would automatically have own prefilled rows for each contest entry where they write their points. Tried to create something like this on my test site. I may be wrong but the list view and query result made me believe into possibility of such feature.
But if this data is joined data then we can see it only in list view, not in form/details (not even in readonly mode). Although when looking at the query in fabrikdebug and running it in phpmyadmin then this data from joined view is returned.
I hope it's not too complex to make it possible
If we could work with joined data from mysql view in form view we would be able to create some kind of "ready for filling in" forms. E.g something like intended here: http://fabrikar.com/forums/index.php?threads/how-to-initially-show-repeat-group.32911/
Or if we had some contest with m jury members and n entries then each jury member would automatically have own prefilled rows for each contest entry where they write their points. Tried to create something like this on my test site. I may be wrong but the list view and query result made me believe into possibility of such feature.
