I have 4 tables: gutter_tbl, screen_tbl, roofing_tbl and master_table
I wanna filter the invoiced field (and other fields) of the first 3 tables but appgini does not support views so I wanna clone these values inside the master_table.
scenario 1 (gutter page):
Code: Select all
gutter_tbl.id = 127
gutter_tbl.invoiced = "yes"
gutter_tbl.add = "Downspot"
Code: Select all
master_table.gutterid = 127
master_table.gutterinvoiced = "yes"
master_table.gutteradd = "Downspot"
master_screenid = ""
master_screeninvoiced = ""
master_table.screendogdoors = ""
master_roofingid = ""
master_rooinfinvoiced = ""
master_table.roofingtype = ""
Code: Select all
screen_tbl.id = 231
screen_tbl.invoiced = "no"
screen_tbl.dogdoors = 3
Code: Select all
master_table.gutterid = ""
master_table.gutterinvoiced = ""
master_table.gutteradd = ""
master_table.screenid = 231
master_table.screeninvoiced = "no"
master_table.screendogdoors = 3
master_table.roofingid = ""
master_table.rooinfinvoiced = ""
master_table.roofingtype = ""
Code: Select all
roofing_tbl.id = 786
roofing_tbl.invoiced = "yes"
roofing.type = "SHINGLE"
Code: Select all
master_table.gutterid =
master_table.gutterinvoiced = ""
master_table.gutteradd = ""
master_table.screenid = ""
master_table.screendogdoors = ""
master_table.screeninvoiced = ""
master_table.roofingid = 786
master_table.rooinfinvoiced = "yes"
master_table.roofingtype = "SHINGLE"
Whos in for the job? Thanks in advance, have a good day.
*sql statements in the hooks might be the way to do it but I couldnt build it myself*