# How to display BDM in table **URL:** \ **Category:** Q&A\ **Created:** [8 February 2017 11:02 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190 "2017-02-08T11:02:45Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\ **Post date:** [8 February 2017 11:02 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/1 "2017-02-08T11:02:45Z")
I need to display the records that are in my BDM in UI Designer, so far I have only been able to display what is in my process variable, through the following code: ` ../API/bpm/caseVariable/{{task.caseId}}/listaTransportadoras` However I need to display my BDM records in a table in the UI Designer, how can I do this? I tried to create an API like this: `../{{context.transportadoras_ref.link}}` And I called the attributes of my BDM like this: `retorno.status` But the return was empty, what do I need to change to return have the attribute value of my BDM? ---
**Author:** ![Sean\_McP](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/sean_mcp/32/932_2.png) [@Sean\_McP](https://community.ofelia.com/u/Sean_McP)\ **Post date:** [9 February 2017 01:03 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/2 "2017-02-09T01:03:43Z")
Have you read the Getting Started Tutorial? All the information you need is in there… [http://documentation.bonitasoft.com/?page=getting-started-tutorial](http://documentation.bonitasoft.com/?page=getting-started-tutorial) regards Seán _PS: While you may not like the answer, it gives a possible solution, please mark as resolved._ ---
**Author:** ![Dibyajit.Roy](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@Dibyajit.Roy](https://community.ofelia.com/u/Dibyajit.Roy)\ **Post date:** [9 February 2017 10:59 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/3 "2017-02-09T10:59:18Z")
Hi Sorry I was Not able to Open the BOS file as I am using a Lower Version of Bonita. I have the BOS file. I will test it out later. For Now , I have Uploaded screenshot of My Pages where I use the context.ref to Pull Data and Display inside the Page. Let Me know If you are able to access the Screenshots and iF it Helps you in any way. Alternately I can open your BOS file once I download a Higher version of Bonita . ---
**Author:** ![Dibyajit.Roy](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@Dibyajit.Roy](https://community.ofelia.com/u/Dibyajit.Roy)\ **Post date:** [9 February 2017 10:59 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/4 "2017-02-09T10:59:48Z")
Hi Sorry I was Not able to Open the BOS file as I am using a Lower Version of Bonita. I have the BOS file. I will test it out later. For Now , I have Uploaded screenshot of My Pages where I use the context.ref to Pull Data and Display inside the Page. Let Me know If you are able to access the Screenshots and iF it Helps you in any way. Alternately I can open your BOS file once I download a Higher version of Bonita . Here Is the Link [https://goo.gl/photos/qdCmhGr3SkzQZFgg6](https://goo.gl/photos/qdCmhGr3SkzQZFgg6) If you want to Display the BDM records inside an Application page(Outside the Portal) .Then you will need a Separate API /bonita/API/bdm/businessData/com.model.Table\_name?q=find&p=0&c=10000 ---
**Author:** ![Dibyajit.Roy](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@Dibyajit.Roy](https://community.ofelia.com/u/Dibyajit.Roy)\ **Post date:** [9 February 2017 09:52 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/5 "2017-02-09T09:52:39Z")
Hi You have the Correct Procedure. Maybe you got the naming incorrect . Inside your Form, Add a text Field. Replace all the text with {{context}} . Preview the Page. It should Pull up the correct Ref link. this is How i check most of Issues . Hope this helps . ---
**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\ **Post date:** [9 February 2017 10:46 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/6 "2017-02-09T10:46:52Z")
Thanks for trying to help me, I did what you indicated but the Text field returned blank by placing {{context}}, So when putting in an input field it returned me this: “{{properties.placeholder | uiTranslate}}” Just to confirm, it’s literally {{context}} in a text field, or the name of my variable that’s receiving my REST API ---
**Author:** ![Sean\_McP](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/sean_mcp/32/932_2.png) [@Sean\_McP](https://community.ofelia.com/u/Sean_McP)\ **Post date:** [31 March 2017 02:10 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/7 "2017-03-31T02:10:33Z")
@romualdo.s.rs _the Text field returned blank by placing {{context}}_ This is expected, because Context only references Business Data, not process variables. It’s really annoying. So if you are getting nothing are you sure you’ve added the BDM to the Data? If not then it will show nothing, if you have then is there any data in it? Add a new External API variable to the page and give is …/API/bdm/businessData/_com.company.model.Customer_?q=find&p=0&c=100 where _com.company.model.Customer_ is your BDM. You **MUST** have the q, c and p parameters. Add a new table to the page In Content click the button so it shows a white X on dark blue (expression or variable) and type the name of your variable above. in COLUMN KEYS - you **MUST** specify the columns you want in the table to show. Note this must be left as _fx_ That’s it should work now… Note as follows: {{properties.placeholder | uiTranslate}} comes back when it cannot parse the value and therefore cannot display anything. It really is {{ context }} in the text field, though we actually put text is to describe it to help us know what it is… ` Context: {{ context }} ` for example. regards Seán ---
**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\ **Post date:** [9 February 2017 10:23 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/8 "2017-02-09T10:23:55Z")
I read the tutorial but did not understand how I can get the contents of my BDM attributes and display in a table in the UI Designer, could you give me an example of how I can do this? I will add the link to my .BOS file from my process, if you can see what I can do to accomplish this task I thank you very much [https://drive.google.com/file/d/0B8aMiLwwVY0nUFl1MUdQYkFaRkk/view?usp=sharing](https://drive.google.com/file/d/0B8aMiLwwVY0nUFl1MUdQYkFaRkk/view?usp=sharing) ---
**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\ **Post date:** [9 February 2017 11:18 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/9 "2017-02-09T11:18:10Z")
I looked your images, and apparently their settings are the same as the way I set it, I believe that when you can take a look at my .BOS file, you will understand why I am not understanding what is happening to not display the information of the attributes ---
**Author:** ![Dibyajit.Roy](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@Dibyajit.Roy](https://community.ofelia.com/u/Dibyajit.Roy)\ **Post date:** [9 February 2017 11:21 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/10 "2017-02-09T11:21:42Z")
OK. In that Case , I will have a look later Today. I can Reply Tomorrow. I have a Question. This page where you want to Display the Attributes. 1. Is it inside a Portal Task ( Portal Form) . 2. Is it a Separate Application Page . Outside the portal . ---
**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\ **Post date:** [9 February 2017 11:42 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/11 "2017-02-09T11:42:55Z")
Answering your question, I believe it is within a task that has this Form (I am new to Bonitasoft and do not know the correct nomenclature). Another thing I checked for an APi External variable as you suggested in the answer, I am sending the link of the image to you to see the result [https://drive.google.com/file/d/0B8aMiLwwVY0nbFBTSE5sUVRMQTA/view?usp=sharing](https://drive.google.com/file/d/0B8aMiLwwVY0nbFBTSE5sUVRMQTA/view?usp=sharing) [https://drive.google.com/file/d/0B8aMiLwwVY0nVDNhTk1nalFIeW8/view?usp=sharing](https://drive.google.com/file/d/0B8aMiLwwVY0nVDNhTk1nalFIeW8/view?usp=sharing) ---
**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\ **Post date:** [9 February 2017 12:16 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/12 "2017-02-09T12:16:13Z")
Reseted my BDM and add a new item that arrest had added: [https://drive.google.com/file/d/0B8aMiLwwVY0ncG10QWFES2t1V1k/view?usp=sharing](https://drive.google.com/file/d/0B8aMiLwwVY0ncG10QWFES2t1V1k/view?usp=sharing) But I can not determine that he brings me the name of the carrier, for example ---
**Author:** ![Dibyajit.Roy](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@Dibyajit.Roy](https://community.ofelia.com/u/Dibyajit.Roy)\ **Post date:** [9 February 2017 12:23 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/13 "2017-02-09T12:23:44Z")
Hi From the Screenshot , I dont see the the task Id variable. You should have a task id Variable Defined . task Id = …/API/bpm/userTask/{{taskId}} ---
**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\ **Post date:** [9 February 2017 12:29 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/14 "2017-02-09T12:29:04Z")
I added the variable, after that I need to change something else, because the result of the table was the same. [https://drive.google.com/file/d/0B8aMiLwwVY0nOEZHQnhCNGl5WEU/view?usp=sharing](https://drive.google.com/file/d/0B8aMiLwwVY0nOEZHQnhCNGl5WEU/view?usp=sharing) ---
**Author:** ![Dibyajit.Roy](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@Dibyajit.Roy](https://community.ofelia.com/u/Dibyajit.Roy)\ **Post date:** [10 February 2017 14:01 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/15 "2017-02-10T14:01:32Z")
Hi I took a look into the BOS file. I realised that If you using a table then context\_ref.link will not work here. Rather you have to define the Actual link it self. Here is the Link that worked for me. …/API/bdm/businessData/com.hss.model.Transportadora?q=find&c=100000&p=0 I have made small adjustments to the BOS file. Do check it out [https://drive.google.com/file/d/0B-MHHSlP6-kMZUVHb3NoeGk4QjA/view?usp=sharing](https://drive.google.com/file/d/0B-MHHSlP6-kMZUVHb3NoeGk4QjA/view?usp=sharing) ---
**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\ **Post date:** [17 February 2017 16:52 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/16 "2017-02-17T16:52:18Z")
Thanks for the feedback, I tried to open the .BOS file that you edited, but it is in a version higher than mine (You sent it in 7.4.2 and I have version 7.3.3 installed) ---
**Author:** ![Dibyajit.Roy](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@Dibyajit.Roy](https://community.ofelia.com/u/Dibyajit.Roy)\ **Post date:** [17 February 2017 16:58 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/17 "2017-02-17T16:58:52Z")
Hi I will try to create a sample in 7.3.3 tomorrow and upload . Did you try with the …/API/bdm/businessData/com.hss.model.Transportadora?q=find&c=100000&p=0 It worked for me. ---
**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\ **Post date:** [20 February 2017 11:30 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/18 "2017-02-20T11:30:00Z")
Good morning, thanks for the feedback. I’ve made some progress in my work and I’m already able to display the BDM table information in the UI Designer, but I do not want to have repeated information inserted into my BDM, can you help me? I am sending the link to the updated .BOS file Many thanks for the help. Link: [https://drive.google.com/file/d/0B8aMiLwwVY0nVXhPemhsQzh0MDA/view?usp=sharing](https://drive.google.com/file/d/0B8aMiLwwVY0nVXhPemhsQzh0MDA/view?usp=sharing) ---
**Author:** ![Dibyajit.Roy](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@Dibyajit.Roy](https://community.ofelia.com/u/Dibyajit.Roy)\ **Post date:** [20 February 2017 13:34 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/19 "2017-02-20T13:34:01Z")
Hi I saw your other post on the same topic. I assume your are using API to fetch Data from your database. Hence there should be two separate API returning data from BDM and the other database, variable1 and variable2 for example. Now, I suggest create a page variable of type javascript. You could refer to the database records by using the $data.variable1 and $data.variable2 . Using a loop, you could compare the values. In case of a unique value, add it to an array. (declare a new array type inside the script) At the end of the loop, return the Array. or you could use something like bdm.setAttribte() = arrayValue Regards ---
**Author:** ![romualdo.s.rs](https://avatars.discourse-cdn.com/v4/letter/r/9fc348/32.png) [@romualdo.s.rs](https://community.ofelia.com/u/romualdo.s.rs)\ **Post date:** [20 February 2017 13:45 UTC](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190/20 "2017-02-20T13:45:30Z")
I put the link to my .BOS file updated in my last comment, would you be able to take a look at how it is now? I created another question here in the forum that explains better how my process is at the moment Link to the question: [http://community.ofelia.com/questions-and-answers/how-compare-two-business-variables](http://community.ofelia.com/questions-and-answers/how-compare-two-business-variables) I am a beginner in Bonitasoft, if you could analyze my new file would be great. If possible give a more detailed example of how to generate this page variable that you commented would be very good too Thank you very much for your attention and patience so far. [Next page](https://community.ofelia.com/t/how-to-display-bdm-in-table/8190.md?page=2)