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: 246
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
Just like in real life, a little thank-you will go a long way. If an answer proved helpful to you, we would definitely be thrilled to receive a positive reaction from you. Besides, a thank-you will signal to other users that you were already helped.
toms
 
Posts: 675
Joined: Wed Nov 08, 2017 8:57 pm

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: 246
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: 2732
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
Just like in real life, a little thank-you will go a long way. If an answer proved helpful to you, we would definitely be thrilled to receive a positive reaction from you. Besides, a thank-you will signal to other users that you were already helped.
toms
 
Posts: 675
Joined: Wed Nov 08, 2017 8:57 pm

Re: search on browseform

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

Toms
That solved my problem, thanks.
Johan
johan
 
Posts: 246
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: 2732
Joined: Mon Jun 15, 2009 9:53 am


Return to General