Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to use inner join in FilterExpression? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Love you Pavlos!

    Cheers!

    Tuesday, October 16, 2012 11:18 AM