# Search Cases Using Business Data variable

**URL:** <https://community.ofelia.com/t/search-cases-using-business-data-variable/10316>\
**Category:** Q&A\
**Created:** [29 July 2020 07:24 UTC](https://community.ofelia.com/t/search-cases-using-business-data-variable/10316 "2020-07-29T07:24:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kalmakhelidze10\_1399](https://avatars.discourse-cdn.com/v4/letter/k/ebca7d/32.png) [@kalmakhelidze10\_1399](https://community.ofelia.com/u/kalmakhelidze10_1399)\
**Post date:** [29 July 2020 07:24 UTC](https://community.ofelia.com/t/search-cases-using-business-data-variable/10316/1 "2020-07-29T07:24:07Z")

</div>

Hello evryone. I want to search cases using business data variables.&nbsp;If I have national id number of someone in my process. I would like search case using this id. For example id is 55555, I want to find the case using this&nbsp;55555.&nbsp;

Thanks in advance.

---

<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:** [31 July 2020 21:08 UTC](https://community.ofelia.com/t/search-cases-using-business-data-variable/10316/2 "2020-07-31T21:08:46Z")

</div>

Hello,

If you want to do that, you have to register in your BDM the case ID.

By conception, the BDM and the process are independent. A process references a BDM and can manipulate it at a moment, but keep in mind MULTIPLE cases, MULTIPLE processes can register a BDM value.

So, by conception, if one case is important for your BDM, you have to create an attribute "myImportantCaseId" in your BDM, and save it when the case creates / modify it.

Second solution, the link between the BDM and the case is stored somewhere in the Bonita Engine database (until the case is not deleted), so you may find a SQL to find this relation? Of course, when the case will be deleted, this information will be deleted at the same time.

Hope this help,
