NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: johanco123 on March 04, 2013, 01:39:38 AM

Title: Nettalk browse filter
Post by: johanco123 on March 04, 2013, 01:39:38 AM

Hi Bruce

In a nettalk browse under 11 Set filter, I add a filter in with some code. It is working fine if the condition is exactly the same, but I need to know how to set the filter to use a part of a word something like a condition "contains" or "like" condition. I want to filter in a string for a specific word or part of it.

loc:FilterWas = 'com:profile = <39>' & clip(loc:profileDB) &'<39>'

Can you please help.

Tanks
Johan

Title: Re: Nettalk browse filter
Post by: kevin plummer on March 04, 2013, 01:44:05 AM

Try Instring.  Set your filter to debug view via the templates so you can see the syntax if you are having probs

Title: Re: Nettalk browse filter
Post by: osquiabro on March 04, 2013, 03:48:36 AM

you can use SQL in your filter i use this code in my filter:

loc:FilterWas =''
loc:FilterWas =' SQL(F.CustomerCode=<39>'&clip(p_web.GSV('CustomerCode'))&' <39> AND A.BillofLadingCreationDate>= <39>'& FORMAT(Loc:Date,@D02) &' <39> AND A.BillofLadingType=<39>I<39> AND (A.BillofLadingStatus<> <39>D<39> AND  A.BillofLadingStatus<> <39>Q<39>) )'     
ThisView{prop:Filter} = loc:FilterWas

if you need a like try this :

'SQL(A.Info LIKE "%Must deliver today%") '

check in clarion help the SQL (use SQL code)