himani.sharma

DYNAMIC LOOKUP

Discussion created by himani.sharma on Jan 14, 2011
Latest reply on Jan 14, 2011 by Dave
Hi
I have made a synamic lookup which fetches data from a CRM system View
SELECT @SELECT:c.AccountId:AccountId@,
@SELECT:c.AccountName:AccountName@,
@SELECT:c.OrgNO:OrgNO@,
@SELECT:c.AccountNo:AccountNo@,
@SELECT:c.Country:Country@,
@SELECT:c.AccountGroup1:AccountGroup1@
from edbap074.externalviews_mscrm.dbo.clarity_account c

i get the message

The WHERE clause must contain "@FILTER@" to work properly. To create a dependent lookup, enclose the lookup internal name in "@" symbols.



I dont use a where here.
the lookup window open shows the contents but i am not able to FILTER.
Why is that.Anyone knows how i can fix this,
Help asap.
Thanks alot

Outcomes