Can anyone help me to find solution for my problem?
I have 1 table - documents:
document_id, user_id, creator_account_id, creator_user_id
and 2 related tables:
account_id, first_name, last_name
user_id, first_name, last_name
is there any way to get 1 table (for criteria in list action) with data:
document_id, user_id, creator_first_last_name ?
collecting first and last names depending on the type of relation? (creator_account_id, creator_user_id)?
or what would be the best solution to sort documents by name and surname of the creator (propel only) in this situation?