# Lazy reference filter in table

**URL:** <https://community.ofelia.com/t/lazy-reference-filter-in-table/10325>\
**Category:** Q&A\
**Created:** [4 August 2020 14:46 UTC](https://community.ofelia.com/t/lazy-reference-filter-in-table/10325 "2020-08-04T14:46:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![mike\_1989256](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@mike\_1989256](https://community.ofelia.com/u/mike_1989256)\
**Post date:** [4 August 2020 14:46 UTC](https://community.ofelia.com/t/lazy-reference-filter-in-table/10325/1 "2020-08-04T14:46:41Z")

</div>

Hello,

I am trying to fill a table with document list data that i gathered from a BDM api call. The object retrieved is a document having a lazy reference on the object person. I would like to display the person's name of each document in that table.

I can't use the variables in the UI to get the lazy reference value because each row has his own lazy reference. In the&nbsp;Column keys section of the UI table, i can't use the&nbsp;filters as following :&nbsp; document.person.name&nbsp;

could you help me display the child object's information of each row?

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [6 August 2020 13:49 UTC](https://community.ofelia.com/t/lazy-reference-filter-in-table/10325/2 "2020-08-06T13:49:08Z")

</div>

Hi, are you able to deploy the person in the API call "-d=person"?

---

<div class="post-metadata">

**Author:** ![Pierre-yves\_Monnet](https://avatars.discourse-cdn.com/v4/letter/p/8edcca/32.png) [@Pierre-yves\_Monnet](https://community.ofelia.com/u/Pierre-yves_Monnet)\
**Post date:** [8 August 2020 20:02 UTC](https://community.ofelia.com/t/lazy-reference-filter-in-table/10325/3 "2020-08-08T20:02:21Z")

</div>

Hello,

You can use the REST API CONTEXT: it will do exactly what you look for.

[http://community.ofelia.com/project/restapicontext](http://community.ofelia.com/project/restapicontext)

Have a look at this video, you will have an explanation.

[https://youtu.be/Vohnf9b12pU](https://youtu.be/Vohnf9b12pU)

Maybe I have to do a video only dedicated to this aspect?

Best,

---

<div class="post-metadata">

**Author:** ![mike\_1989256](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@mike\_1989256](https://community.ofelia.com/u/mike_1989256)\
**Post date:** [7 August 2020 09:57 UTC](https://community.ofelia.com/t/lazy-reference-filter-in-table/10325/4 "2020-08-07T09:57:47Z")

</div>

Hello, I didn't understand clearly your response. Do you mean to have the API call in the UI as follows :

../API/bdm/businessData/com.bpm.document?q=getListById&p=0&c=99&f=1=3&d=person&nbsp; ?

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [7 August 2020 11:14 UTC](https://community.ofelia.com/t/lazy-reference-filter-in-table/10325/5 "2020-08-07T11:14:11Z")

</div>

Yes, that is what I meant, adding &d=person.  
As a disclaimer, I have to say that I'm not very good at bdm api calls since I don't know the api. For the "person" part, I usually check the response of the api without deploy and then I try to deploy on the necessary field.

---

<div class="post-metadata">

**Author:** ![mike\_1989256](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@mike\_1989256](https://community.ofelia.com/u/mike_1989256)\
**Post date:** [7 August 2020 11:24 UTC](https://community.ofelia.com/t/lazy-reference-filter-in-table/10325/6 "2020-08-07T11:24:26Z")

</div>

even by adding the &d=person, no results are shown. here is the API response for the call without the &d parameter :

[  
&nbsp;&nbsp; &nbsp;{  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"persistenceId": 2,  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"persistenceId\_string": "2",  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"persistenceVersion": 0,  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"persistenceVersion\_string": "0",  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"creationDate": "2020-08-07T11:17:28.582208Z",  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"prefix": "A B",  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"links": [  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;{  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"rel": "person",  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;"href": "/API/bdm/businessData/com.bpm.document/2/person"  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;}  
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;]  
&nbsp;&nbsp; &nbsp;}  
]

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [7 August 2020 12:22 UTC](https://community.ofelia.com/t/lazy-reference-filter-in-table/10325/7 "2020-08-07T12:22:21Z")

</div>

I looked at the documentation for 7.11 and I found this https://documentation.bonitasoft.com/bonita/7.11/variables#toc1. It talks about a way to retrieve the information from a lazyRef, but only for one business data. I don't know if there is a way to retrieve the information for all of them...  
Also, if you are using the Bonita 7.11, there is a feature that let's you autogenerate the form of the data model by drag and dropping an BDM object name. (I think it was introduced in 7.11)
