p_web.SessionId in Browse not working

[johanco123]

Hi Bruce

I use a memory file in my dictionary with a field as SessionID String(256) in the table. I populate the file with a process and store the 
WODQ:SessionId = p_web.SessionID

If I add the WODQ:SessionId in my browse it is the same as the p_web.SessionID.

I want to filter now on WODQ:SessionId with the following statement in (11 Set Filter)     
    loc:FilterWas = 'WODQ:SessionId = <39>' & 'p_web.SessionId' & '<39>'
    ThisView{prop:Filter} = loc:FilterWas

The browse does not display any filtered records for the session id. Any other filter works on the table.

Any Suggestion

Regards
Johan

[Bruce]

loc:FilterWas = 'WODQ:SessionId = <39>' & clip(p_web.SessionId) & '<39>'

[johanco123]

Tanks Bruce

If I change it not to be equals to the session ID it still display all the session ID?

loc:FilterWas = 'WODQ:SessionId <> <39>' & clip(p_web.SessionId) & '<39>'

tanks
johan

[Bruce]

if you go to the template settings for that browse, there's a "debug" option on the first tab. Something along the lines of
Send Order/Filter to debugview.
that way you can see what the actual filter is set to, and that'll probably explain the result set you are getting.

cheers
Bruce

[kevin plummer]

look at the filter in Debug and also try

loc:FilterWas = 'WODQ:SessionId ~= <39>' & clip(p_web.SessionId) & '<39>'

or

loc:FilterWas = 'WODQ:SessionId <<> <39>' & clip(p_web.SessionId) & '<39>'

<> can sometimes cause problems

[johanco123]

Tanks Kevin
It is working now with the <<>

Regards
Johan