Forums

export xls from 2 tables to 1 file

admin_wiky 29 Jan, 2016
Hi Bob,

I need to get data from 2 different tables to 1 xls file.
I need to get one column from second table . I try it by relations, but it doesnt work.

Maybe I have incorrectly set xls export action.


thank you
GreyHead 29 Jan, 2016
Hi homeopat,

Maybe you have :-(

What is the question?

Bob
admin_wiky 04 May, 2016
Hi bob,

I have 1 DB read where is master table as model1 and relation table as model2 and dont know, how set xls export with 2 models.
it doesnt export data although I see 2 models in debugger.
GreyHead 04 May, 2016
Answer
Hi Homeopat,

You need to merge the two sets of results into one coherent sub-array of the $form->data[''] array then you can use the Data Path setting in the XLS Export action to export the result.

Hard to say more from the info here.

Bob
admin_wiky 06 May, 2016
Thank you, I thought that😉
This topic is locked and no more replies can be posted.