Page 1 of 1
search on browseform
Posted: Wed Mar 14, 2018 7:22 pm
by johan
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
Re: search on browseform
Posted: Wed Mar 14, 2018 9:10 pm
by toms
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.
Re: search on browseform
Posted: Wed Mar 14, 2018 10:31 pm
by johan
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
Re: search on browseform
Posted: Wed Mar 14, 2018 11:26 pm
by admin
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
Re: search on browseform
Posted: Thu Mar 15, 2018 5:36 am
by toms
Johan,
Just remove the semicolon (“ ; ”) at the end of your queries.
Re: search on browseform
Posted: Thu Mar 15, 2018 9:54 am
by johan
Toms
That solved my problem, thanks.
Johan
Re: search on browseform
Posted: Thu Mar 15, 2018 11:37 am
by admin
.