different tables in browse
Posted: Sun May 13, 2018 2:52 pm
Can I show data of several sql tables in one browse form and then open a different edit form depending on which record was clicked on?
Build a Browse SQL that has this structure. WHERE (1 = 1) is important, otherwise the sorting/search won't work!
Code: Select all
SELECT * FROM (
SELECT ...
FROM t1
WHERE ...
UNION ALL
SELECT ...
FROM t2
WHERE ...
UNION ALL
SELECT ...
FROM t3
WHERE ...
) T
Left join ... = T...
WHERE (1 = 1)
order by ... descThen add some Custom Code (JS) to determine which Edit Form to open:
Code: Select all
function nuSelectBrowse(e) {
var rowNum = String(e.target.id).split('_')[1];
var colProjCell = 'nucell_' + rowNum + '_' + '1'; // project is column 1
var r = $('#' + colProjCell).attr('data-nu-primary-key');
var cellId = $('#' + colProjCell).attr('id');
var cellValue = $('#' + cellId).html();
if (cellValue == 'Project1') {
nuForm('5a8990d7a688ed1', r, '', '', '1');
} else
if (cellValue == 'Project2') {
nuForm('5a8991775388890', r, '', '', '1');
}
}