Question about BusinessDataRepository Query Handling

dig24

Dear Ivy Team,

As I understand it, we have the iwa_businessdatatable in the database to store BusinessData. So when I use the BusinessDataRepositoryto perform a query like the example below, I expected it to query the database.
However, based on the logs, it appears that the query is being executed against Elasticsearch instead. Could you please clarify whether queries made via BusinessDataRepositoryare sent to Elasticsearch or the database?

Eg: BusinessDataRepository.search(Example.class).textField("state)..containsPhrase(state)).execute().getAll();

Thanks in advance.

Louis Müller

Hello dig24

Based on your last request, I assume that you are dealing with v10. Please take a look at the Business Data chapter, see https://dev.axonivy.com/doc/10.0/designer-guide/data-modeling/business-data/index.html

Here you will find the following information https://dev.axonivy.com/doc/10.0/designer-guide/data-modeling/business-data/usage.html#search

The search capabilities of the Business Data Store are based on Elasticsearch and therefore fast and powerful.

To summarize, the business data is duplicated to Elasticsearch, which is then used for the search.

dig24

Louis Müller

Thanks for your support @Louis Müller

I wanna know the under the hood of BusinessDataRepositorysince I'm facing the issue with that. Somehow, the query couldn't retrieve any data even the data exist another place. I doubt it the createdDate data/format type in the ES different format/zone with the input. But it's still not right. By the way, have you faced any issue like that?

Code: BusinessDataRepository.search(Example.class).textField("state)..containsPhrase(Enum.state)).execute().getAll();
Raw Query:{"size":1000,"query":{"bool":{"filter":[{"match_phrase":{"state":"DRAFT"}},{"range":{"createdDate":{"lt":"2025-04-19T11:23:19.345+0700"}}}]}},"_source":{"excludes":["*"]}}

Louis Müller

@dig24 do you use dateTimeField(string) to configure this date filter? Could you please share the full code snippet that shows how you set this date filtering?