nuBuilder Forum

Good day!

This is my sql that works just fine in a browse screen but what doesn't work is the search, it won't find anything. Just an empty table is shown. Am I missing something here?

SELECT
*
FROM (SELECT
t.*,
cu.client,
mgr.name AS manager
FROM t
LEFT JOIN cu
ON t.id = emp.id
LEFT JOIN cu AS mgr
ON cu.mgr_id = mgr.id
WHERE (f = ''
AND (usr = '#USER_ID#'
OR f <> 'globeadmin'))) T
ORDER BY d DESC

Amit,

Add a WHERE 1 as shown below. This is required for the "query parser" to work correctly.

It works! Your trick did the job!

.