I am using Commerce Server 2007's JoinTable feature to join an external
table
to the catalog resultset. This works nicely. I was hoping to use the
SqlWhereClause prtoperty to filter based on fields from the external
table.
The CS2007 API complains about these columns not existing even though I
can
clearly see them in the resultset from the CatalogSearch call.
Does SqlWhereClause sup****t JoinTable tables? If not, is there a
different
course of action I can take rather than retrieving a bigger resultset than
I
need and then filtering it with a DataView or XPath.
Thanks
Brian
