10000 🐛 Bug Report: select query in a relationship database · Issue #5880 · appwrite/appwrite · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

🐛 Bug Report: select query in a relationship database #5880

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.

Sign up for GitHub

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

Jump to bottom
Open
2 tasks done
monofactory opened this issue Jul 26, 2023 · 6 comments
Open
2 tasks done

🐛 Bug Report: select query in a relationship database #5880

monofactory opened this issue Jul 26, 2023 · 6 comments
Assignees
@fogelito
Labels
bug Something isn't working feature / relationships Fixes and upgrades for database relationships product / databases Fixes and upgrades for the Appwrite Database.

Comments

@monofactory
Copy link

👟 Reproduction steps

Query.select([
"title",
"category",
"imageLinks",
"uid",
...
"users.*" // relationship collection "users" All of the user's data is imported
]),

👍 Expected behavior

Query.select([
"title",
"category",
"imageLinks",
"uid",
...
"users.name" // Only the data I want ==> not working
]),

👎 Actual Behavior

AppwriteException: general_unknown, Server Error (500), #0 ClientMixin.prepareResponse (package:appwrite/src/client_mixin.dart:73:9)
#1 ClientIO.call (package:appwrite/src/client_io.dart:373:14)

🎲 Appwrite version

Version 1.3.x

💻 Operating system

MacOS

🧱 Your Environment

appwrite 1.3.8

👀 Have you spent some time to check if this issue has been raised before?

  • I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?
@monofactory monofactory added the bug Something isn't working label Jul 26, 2023
@joeyouss joeyouss self-assigned this Jul 26, 2023
@joeyouss joeyouss added the product / databases Fixes and upgrades for the Appwrite Database. label Jul 26, 2023
@github-actions github-actions bot mentioned this issue Aug 1, 2023
Closed
@joeyouss
Copy link
joeyouss commented Aug 8, 2023

HI
Querying is currently not supported in relationships.

@joeyouss
Copy link

Hi @monofactory shall I close this issue if no additional help is required here?

@abnegate
Copy link
Member
abnegate commented Sep 8, 2023

Hey @monofactory, is this still an issue for you in 1.4.x? If so, are you able to add the appwrite container logs here?

@abnegate abnegate assigned abnegate and unassigned joeyouss Sep 8, 2023
@abnegate abnegate added the feature / relationships Fixes and upgrades for database relationships label Sep 8, 2023
@abnegate abnegate assigned fogelito and unassigned abnegate Sep 16, 2023
@fogelito
8000
Copy link
Contributor
fogelito commented Oct 3, 2023

hey @monofactory I am pretty sure, This should work...
Is this still an issue?
If this is on self-hosted, please provide logs, if it is on the cloud, please check after recent update
Thank a lot

This was referenced Nov 13, 2023
Open
Closed
@mattie-cmsp
Copy link

I wanted to chime in on this, as it relates to the FR I opened #7033 .

I'm affected by the same issue. But, this is not a bug, this is an FR as the documentation and code states that the features required to resolve this need are potentially planned for a future release.

Queries
Queries are currently not available in the experimental version of Appwrite Relationships but will be added in a later version.

I don't know if there is a place to track planned features like this one. And as I've spent some time looking through the code for Appwrite and Utopia Database, I'd be willing to contribute code changes to both or either this issue and/or my interim FR.

@redleeder
Copy link

+1 For query support for relationships. I have a use case where I would love to have the ability to only have certain fields return for related documents.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@fogelito fogelito

Labels
bug Something isn't working feature / relationships Fixes and upgrades for database relationships product / databases Fixes and upgrades for the Appwrite Database.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
6 participants
@monofactory @redleeder @abnegate @fogelito @joeyouss @mattie-cmsp
0