Using Linked-Entity in addCustomFilter

(0) Share

Report

Posted on by Ferdy Griffioen

At this moment I know how to use the addCustomFilter in combination with addPreSearch (and the remove variants). All this works perfectly when passing a filterXml like:

    <filter type="and">
      <condition attribute="name" operator="eq" value="test123" />
    </filter>

But I just can't figure out how to use linked-entities in the addCustomFilter and whether it is actually possible. I've tried the following:

    <link-entity name="account" from="accountid" to="parentaccountid">
      <filter type="and">
        <condition attribute="name" operator="eq" value="test123" />
      </filter>
    </link-entity>

It is still the same filter but it is now placed on the parent account of the account. With this filterXml I want to get all the accounts that have the account 'test123' as the parent account.

The problem is that the filter doesn't work in the addCustomFilter but it does return results in the AdvancedFind.

Is there a way to use linked-entities in the addCustomFilter method, if so what am I doing wrong?

*This post is locked for comments

I have the same question (1)

All responses (14)

Answers (0)

Hosk on at

Like (0)

Report

To get the right text for link entities, the best way is to create an advanced of the search you want to do and then click the download Fetch XML button

this will then give you a copy of the fetch XML and the link entity.

Was this reply helpful? Yes No
Ferdy Griffioen 25 on at

Like (0)

Report

@Ben Hosking:

You can not pass the entire fetchXML to the addCustomFilter, it must be the filterXML part.

I've tried to make correct fetchXML with linked-entities and then take the filterXML part, but it doesn't work

Was this reply helpful? Yes No
LIONEL TEULIERES 70 on at

Like (0)

Report

have you find a solution?

Was this reply helpful? Yes No
Ferdy Griffioen 25 on at

Like (0)

Report

Unfortunately I haven't.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Have you tried this:

<link-entity name="account" from="accountid" to="parentaccountid" link-type="outer">

<filter... etc

Was this reply helpful? Yes No
Ferdy Griffioen 25 on at

Like (0)

Report

@ Adam Vero,

As I've state before, the XML you pass must start with 'filter'. Therefor I can't try your idea as it starts with 'link-entity'.

Was this reply helpful? Yes No
BiR 180 on at

Like (0)

Report

Have you found a solution?

I am trying to do exactly the same.

Was this reply helpful? Yes No
BiR 180 on at

Like (0)

Report

I have also created a stackoverflow for your question:

stackoverflow.com/.../using-linked-entity-in-addcustomfilter

Was this reply helpful? Yes No
Suggested answer

Linn Zaw Win 3,407 on at

Like (0)

Report

If the out of the box addCustomFilter method doesn't work for link entity conditions, try this custom addCustomFilter method

madcomputerist.blogspot.com/.../adding-additional-condition-to-lookup.html

Was this reply helpful? Yes No
CU20091903-0 55 on at

Like (0)

Report

Hi Ferdy

I am also faced with the exact same issue and I can't seem to crack it.

Have you managed to find a solution for this yet?

Kind Regards

Was this reply helpful? Yes No