locked
How to use inner join in FilterExpression? RRS feed

  • Question

  • Hi All,

    I need one help. please see the below code:

        FilterExpression filterLeads = new FilterExpression();
                filterLeads.FilterOperator = LogicalOperator.And;
                //filter.AddCondition("regardingobjectid", ConditionOperator.Equal, entityRecordGuid);
                filterLeads.AddCondition("websiteurl", ConditionOperator.Equal, strWebsiteURL);
                filterLeads.AddCondition("leadid", ConditionOperator.Equal, "lead.new_PrimaryLead");

    Here, I wrote first condition to fetch only those records contains the said URL.

    But in second condition, i need to fetch those records which satisfies leadid = new_PrimaryLead that is not any value filter but the inner join kind of filter i need.

    Does it possible?

    Please help, thank you in Advace.

    Dhaval Panchal


    Tuesday, October 16, 2012 9:38 AM

Answers

  • Hi,

    you can do this using LinkEntity. Check this and this.

    Greetings,

    Pavlos


    Please mark this reply as an answer and vote it as helpful if it helps you find a resolution to your problem.
    View my latest gallery contribution here.
    Visit my blog here.

    Tuesday, October 16, 2012 9:42 AM

All replies

  • Hi,

    you can do this using LinkEntity. Check this and this.

    Greetings,

    Pavlos


    Please mark this reply as an answer and vote it as helpful if it helps you find a resolution to your problem.
    View my latest gallery contribution here.
    Visit my blog here.

    Tuesday, October 16, 2012 9:42 AM
  • Love you Pavlos!

    Cheers!

    Tuesday, October 16, 2012 11:18 AM