nuBuilder Forum

Posted: **Sat Apr 04, 2015 11:41 pm**

I'm trying to create a lookup form where the records are filtered if the field sysuser_id = the current user. Or if the globeadmin is running the report. For some reason I can only get one of the conditions to work. If I use the SQL below the look-up works fine for the globeadmin but when the user logs in it will filter the look-up properly but when I select a "Company" it fills in the text "many records" on the form.

Code: Select all

SELECT * FROM company WHERE sysuser_id = '#nu_user_id#' OR 'globeadmin' = '#nu_access_level#';

Any ideas how I can do this so it is filtered for user but the globeadmin can see everything?

Posted: **Tue Apr 07, 2015 1:25 am**

sbigelow,

You need brackets around you where clause.

Code: Select all

SELECT * FROM company WHERE (sysuser_id = '#nu_user_id#' OR 'globeadmin' = '#nu_access_level#');

Because nuBuilder may add extra stuff on the end if you are using the search.

Code: Select all

SELECT * FROM company WHERE sysuser_id = '#nu_user_id#' OR 'globeadmin' = '#nu_access_level#' OR something else;

Could give you a weird result.

Steven

Posted: **Tue Apr 07, 2015 1:50 am**

You are right. Thanks! That fixed it.

Posted: **Tue Apr 14, 2015 1:22 am**

nuBuilder Forum

many Records on look-up

many Records on look-up

Re: many Records on look-up

Re: many Records on look-up

Re: many Records on look-up