I am working to retrieve work object data by using report definition configuration by having elastic search as database
I have created an custom search properties and dedicated index for App-Name-work-travel class. After that i reindexed dedicated indexes in search landing page. I am have created a report definition in App-Name-work-travel class. I have chossed Prefer Elasticsearch index in data access tab.
While runnning report i am getting results from elastic search(i have ensured it is returning from elastic search by seeing elastic search query in tracer )if i configured single value properties like .FirstName, .LastName.
But i am trying to use .Traveller.FirstName. traveller is a single page property while trying to run report definition i am seeing SQL query in tracer.
Is there any possible way to retrieve results from elastic search for embedded properties.
Thanks @tiruk . But while trying to run Report definition(source --> prefer elastic search in data access tab in Report definition) in pxRetrieveSearchData activity sql query is found (while checking with tracer sql query is found, no elastic search query is found in tracer). How i will ensure pxRetrieveSearchData is retrieving from elastic search index.