search on browseform

Questions related to using nuBuilder Forte.

search on browseform

Postby johan » Thu Mar 15, 2018 3:52 am

Hi

When I open my form (browse form) and search on a name of my cliënt, the list shows all the items and highlights the correct names red.
I thought that only the correct items would be shown in the list.
Is this a bug?
Johan
johan
 
Posts: 251
Joined: Sun Feb 27, 2011 7:46 pm
Location: Belgium

Re: search on browseform

Postby toms » Thu Mar 15, 2018 5:40 am

Johan,

The normal behavior is that the records are filtered AND the search strings are highlighed.
Does it happen just in one form and what does your SQL query look like?
Depending on the structure of the query, additional brackets may have to be inserted.
toms
 

Re: search on browseform

Postby johan » Thu Mar 15, 2018 7:01 am

Toms
I'm having 2 browseforms, both with the same behaviour.
My sql looks like this
Code: Select all
select * from consult c
inner join zzzzsys_user z on c.con_user_id = z.zzzzsys_user_id
inner join zzzzsys_access a on a.zzzzsys_access_id = z.sus_zzzzsys_access_id
where con_usergroup_id = '#USER_GROUP_ID#';


Thanks for your help
Johan
johan
 
Posts: 251
Joined: Sun Feb 27, 2011 7:46 pm
Location: Belgium

Re: search on browseform

Postby admin » Thu Mar 15, 2018 7:56 am

Johan,

If you type nuCurrentProperties().browse_sql in the console, you will see how the records are filtered in the WHERE clause.

That should let you know why you are getting the results you are getting.

Steven
admin
Site Admin
 
Posts: 2972
Joined: Mon Jun 15, 2009 9:53 am

Re: search on browseform

Postby toms » Thu Mar 15, 2018 2:06 pm

Johan,

Just remove the semicolon (“ ; ”) at the end of your queries.
toms
 

Re: search on browseform

Postby johan » Thu Mar 15, 2018 6:24 pm

Toms
That solved my problem, thanks.
Johan
johan
 
Posts: 251
Joined: Sun Feb 27, 2011 7:46 pm
Location: Belgium

Re: search on browseform

Postby admin » Thu Mar 15, 2018 8:07 pm

.
admin
Site Admin
 
Posts: 2972
Joined: Mon Jun 15, 2009 9:53 am


Return to General