Can I use Doctrine Paginator with the Search query about search

[MrHash]

You can. I'll add an example as soon as possible.

[pdrosos]

Thank you very much! Could we expect the example soon?

[MrHash]

So you cannot use the Doctrine ORM paginator because it is specific to the ORM. However i added an example for Pagerfanta and it is possible to use Zend Paginator or other generic pagination libraries in the same way.

[MrHash]

Also another fork talkspirit@6ca22d9 has a paginator implementation but i'm not sure if it's necessary given that there are third party pagination libraries available.

[pdrosos]

Thank you very much for the example! I use Zend Framework 2 and MySQL database. Some of the searchable data is synchronized in ES. As far as I understand, I need to add all fields, which are used for filtering the data in ES too and make the filtering via the DoctrineSearch query, used in my Zend Paginator Adapter, not in the underlying Doctrine query, used for hydration the results, is this correct? Now the filtering conditions are in the Doctrine query, but if the paginator adapter uses the DoctrineSearch query it doesn't seem correct any more.

Thank you in advance for your help!

[MrHash]

OK if you are using ES only for searching in combination with MySQL you can use the Doctrine\Search\Query::hydrateWith($doctrineQuery) technique as shown in the docs. This will select the items from your mysql database by id. In this case you can set source=false in your ElasticSearchable annotation.

If your results are different from doing a query on MySQL, then this is likely because ES has different techniques for storing tokens and doing queries. Have you checked your mappings and analyzers configuration in ES? Also the type of ES search query will vary results, e.g. Match, MultiMatch etc.

[pdrosos]

Yes, I am using ES only for searching and basically the data, needed for a full text search is currently synchronized with ES. I am using the Doctrine\Search\Query::hydrateWith($doctrineQuery) method. It seems to work fine.
My question is about the extra parameters I need to add to the query to filter the full text search results, returned from ES.
For example let's have Image with title and description. Title and description are in ES and are used for full text search. But the image has also isActive property and Creator, who has isActive property. I need to filter the ES results and get only the images which have isActive = true and Creator with isActive = true. These properties are not in ES but are added as Where conditions in the Doctrine hydration query.
Image and Creator have also other properties, needed for filtering the full text search results. Should I add them all in ES and filter the results in ES via the Elastica query, but not in MySQL with the Doctrine hydration query?

[MrHash]

Since ES is doing your search job for you you should sync your Image and Creator properties to ES also and use the correct ES query to do all the search work, then simply use the ORM lookup hydration query as provided. In this case isActive could be type="boolean" and Creator type="string" index="not_analyzed" if it is an ID.

[pdrosos]

Great, thank you very much! It was important to clarify that it's not correct to use the Doctrine hydration query for additional filtering of the search results.

Have a nice day!