02-17-2011 08:49 AM
In Act.Framework.Lookups there is a method LookupContactsReplace and one of the overloads is:
public ContactLookup LookupContactsReplace( string sql, bool includePrivate, bool includeUsers )
I wonder if anyone can tell me the format of the sql to use in the first parameter. Presumably this overload is when you'd like to replace the criteria objects with a single sql statement...I just cannot "guess" at the format. An example would be nice. For example, does it just need a WHERE clause and what must the query return...contact ID guids? Can you SELECT from other tables? I tried a bunch of things and it doesn't throw an exception but never gives me anything.