browse screen search not working

[amit]

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

[toms]

Amit,

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

Code: Select all

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 WHERE 1
ORDER BY d DESC

[amit]

It works! Your trick did the job!

[admin]

.