subform lookup filtering

[Timo]

Hi all, my subform contains lookup fields, each row contains one. If I enter a code in the lookup input and press enter, the lookup form opens (So far, so good). But the form is not filtered. Only records that match the code should be displayed. This also does not work in the "Access Levels"/ Tab "Forms" . Is it a bug?

[admin]

Timo,

Can you post an example of what you mean?

Steven

[Timo]

Let me try. Open up [Access Levels] from home, select the tab [Forms]. In the Grid, enter a code in the form field (lookup). e.g. a string form. After hitting the enter key, a popup form opens.
I expect the browse form to be prefiltered, showing only records that contain form. This is not the case, all records are shown. As mentioned before, this just happens with lookup object in a subform grid. In a normal edit form it works just fine. I hope it's more clear now...

[admin]

Timo,

Sorry, I meant a screen shot.

(make it as easy for me to understand as you can.)


Steven

[Timo]

1. type nu in the lookup field, hit [RETURN] or click the search icon.

acclevel.png

2. the browse popup opens but no filter is applied.

popupbrowse.png

[admin]

Timo,

Is it the same with other lookups?

Steven

[Timo]

It happens in another form of mine, too. But I'm glad I found a solution. The important thing is that the brackets are set correctly. The access levels form uses the form nunonsystemform as lookup browse form. I've added two brackets around the where clause and all works fine. I applied the same fix to my other form.

SELECT * FROM zzzzsys_form
WHERE ((zzzzsys_form_id NOT LIKE 'nu%' AND sfo_type != 'subform')
OR zzzzsys_form_id IN ('nuaccess', 'nuuser', 'nulaunchdates', 'nutranslate', 'nupassword', 'nufile', 'nuuserhome'))
ORDER BY sfo_code

[Timo]

You think this fix can be put on GitHub? Thank you.

[admin]

Timo,

I think I've fixed the problem in the latest patch.

Let me know if it works for you now.

Steven

[Timo]

Hi, although the search string (nu) is highlighted in red, all records are shown and the filtering shows no effect at all.