Replies posted by Jbb
I guess you’re right : I should use a calendar table and JOIN my resources tables to this table in the explore. I eventually found and implemented another solution. I created a new view : union_group_message. This view has a derived table making the UNION between my 2 tables.SELECT creation_date, group_id, TRUE AS is_group, FALSE AS is_message, NULL AS message_idFROM `groups`UNION ALLSELECT creation_date, group_id, FALSE AS is_group, TRUE AS is_message, message_idFROM messages`;; The issue though is that I’ll have to maintain the message table at two places. With the calendar table solution I feel that I don’t have to duplicate my views thanks to JOINs in the model.
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.