search on browseform

[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

[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.

[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

[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

[toms]

Johan,

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

[johan]

Toms
That solved my problem, thanks.
Johan

[admin]

.