Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Select Index instead of document with All/Any support #479

Open
MichaelPetrinolis opened this issue Mar 13, 2023 · 0 comments · May be fixed by #480
Open

Select Index instead of document with All/Any support #479

MichaelPetrinolis opened this issue Mar 13, 2023 · 0 comments · May be fixed by #480

Comments

@MichaelPetrinolis
Copy link

As mentioned in #467 and #422, there are times that we need to query an index to retrieve some values, but the documents should be filtered with multiple indexes. Unfortunately this can't be done now, as the IQuery returns documents (a large payload, which must be materialized in memory to read the specific info) or use the IQueryIndex but without support for All/Any.

A solution is to introduce a ForAdvancedIndex() method to IQuery, which would select from the Index table joined with the document table. The method should return an IQuery instance, where then all the other methods work as the simple For method. The method will only allow to select from Map Indexes.

@MichaelPetrinolis MichaelPetrinolis linked a pull request Mar 13, 2023 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant