Formatted search

[Former Member]

Hello Everyone,

I am trying to set the filter on a formatted search. So if I type something and then pull up the formatted search the filter only pulls in results with the first few letters typed. Also it is possible to return the first field but search based on the criteria in the second or third field by default??

Thank you

-Chuck

[Former Member · Accepted solution]

you could check the field for a value using the $ dereference.

If you find a value you can execute a sql query with the term like in the where clause

ie where cardcode like $[ORDR.Cardcode]

then if you don't find a value in the dereferenced field don't use like.

if $[ORDR.Cardcode] = '' begin

select ...

end

else

begin

select ... where cardcode like $[ORDR.Cardcode]

end

i don't know if it works- u need to try it....

[Former Member]

If i can't set a filter is there any way to let the user type in the fs and have the list sort by the second column rather than the first?