Hi,

I want to show accounts where the Type = "Dealer" or Type = "Distributor in lookup prefilter.

Kindly let me know how to achieve this task in SalesLogix web ver 7.5.4.

Thanks in Advance.

You need to inject HQL into the lookup condition.  Set the pre-filter conditional operator to 'Not Equal to', and the FilterValue to the exact text below:

XXX' and Account.Type IN (‘Dealer’, ‘Distributor’ ) and 'A' != 'B

Note the missing single quotes on the beginning and end - the lookup control will add these for string properties.

This will generate the SQL:

Account.Type != 'XXX' AND Account.Type IN (‘Dealer’, ‘Distributor’ ) AND 'A' != 'B'

Love it!

As the old saying goes, there's ore than 1 way to skin a cat. 

I've not tried this in the 8.0 lookups (or done anything with 8.0 lookups for that matter), so the technique may be different.