orientechnologies / orientechnologies/orientdb-docs
Expanding Embeddedlist Columns in a Select SQL Query
Nobody has claimed this yet.
- Dominant language
- CSS
- Stars
- 59
- Forks
- 165
- PR merge metrics
- No merged PRs in 30d
Description
I have a vertex that has embeddedlist columns that reference records in other vertices with the @rids. If I do a simple select, I can see the @rids for this embedded column and if I click on it and I can see the referenced record. How do I select the embedded values in an SQL? I tried expand() on the column and the only thing I see if still the @rid.
Kindly see an example below. How do I display a contact and all embedded phones in one query?
Contact
Name ---- STRING
Description ---- STRING
Phone ---- EMBEDDEDLIST ----> @rid of corresponding record in Phone vertex displayed
Phone
Home Phone ---- STRING
Office Phone. ---- STRING
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing the issue's Contact and Phone vertex example and the reported expand() behavior. Determine whether the documentation should explain a supported SQL query or clarify the limitation, then document the expected result for displaying a contact with its embedded phones. No documentation file or test is named in the issue.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, documentation
- Issue type
- Documentation
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100