Answers to: Get data from database directly not via ElasticSearchhttps://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch<p>Hi everyone, I have a case can not get data via ElasticSearch, I want to get data from iwa_bussiness in the database directly. Have any Ivy API to support this case?. Thank!</p>enThu, 29 Aug 2019 04:16:58 -0400Comment by Alex Suter on Alex Suter's answerhttps://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch#3946<p>We don't provide an API for that and there is no plan to provide such an API in future. What's the problem to end up with Elasticsearch?</p>Alex SuterThu, 29 Aug 2019 04:16:58 -0400https://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch#3946Comment by Phuoc Nguyen on Alex Suter's answerhttps://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch#3945<p>Thank for your answer Alex Suter. My problem still not solved</p>Phuoc NguyenThu, 29 Aug 2019 04:15:09 -0400https://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch#3945Comment by Alex Suter on Phuoc Nguyen's questionhttps://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch#3942<p>See my answer below. Why do you care about this?</p>Alex SuterThu, 29 Aug 2019 02:36:16 -0400https://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch#3942Answer by Alex Suterhttps://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch/3941<p>As far as you make a search with <code>ivy.repo.search(...)</code> you will end up an in an Elasticsearch query. If you load your business data by <strong>id</strong> with <code>ivy.repo.find(...)</code> there will be no Elasticsearch query. It is not possible to load a list of BusinessData directly from SystemDb.</p> <p>At the end of the day, you should not care about our internals.</p>Alex SuterThu, 29 Aug 2019 02:35:14 -0400https://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch/3941Comment by Phuoc Nguyen on Phuoc Nguyen's questionhttps://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch#3940<p>Hi Alex Suter, In my case I want to get list of dossier from database directly.</p>Phuoc NguyenWed, 28 Aug 2019 23:10:01 -0400https://answers.axonivy.com/questions/3935/get-data-from-database-directly-not-via-elasticsearch#3940