Get attributes from RELATE?

[santiagodonoso]

I have the following RELATE with a "price" attribute in it
RELATE user:1->bought->item:1 SET price=8;

When I select the data, I do not get the "price" attribute that was set in the relation.
SELECT ->bought->item AS bought, * FROM user:1;

Question:
How do I get attribute/s that are set in a RELATE?

[zecar]

you can try:

SELECT ->bought as bought from user:1 FETCH bought

[anonimusprogramus]

This is similar case that I tried, it works.

--empty nodes
delete buyer;
delete product;
delete bought;

--create buyer
create buyer:1 content {
  name: 'buyer1'
};

create buyer:2 content {
  name: 'buyer2'
};

--create product
create product:1 content {
  name: 'product1',
  price: 10
};

create product:2 content {
  name: 'product2',
  price: 20
};

create product:3 content {
  name: 'product3',
  price: 30
};

--create relation
relate buyer:1->bought->product:1 set qty=10, time.bought=time::now();

relate buyer:2->bought->product:1 set qty=11, time.bought=time::now();
relate buyer:2->bought->product:2 set qty=12, time.bought=time::now();
relate buyer:2->bought->product:3 set qty=13, time.bought=time::now();

--querying edge's attributes
select *, ->bought.* from buyer:2;

--querying all products buyer:2 has bought
select *, ->bought->product.* from buyer:2;

When querying using many selects, we need to use alias (AS) to prevent previous select being overwritten (see #51)

--querying with alias
select *, ->bought.* as transaction, ->bought->product.* as products from buyer:2;

--querying another direction
select *, <-bought.* as transaction, <-bought<-buyer.* as buyers from product:1;

Btw, I use Thunder REST API Client when executing those commands (see #193)

Cheers 😄

[ashadbubt]

Bro how can make function and use it in query like mysql function .
And suggest me for understand " querying another direction " its look confusing
thank you for you effort

[anonimusprogramus]

Wish I could help, I'm still learning too 😅

Nevertheless these are early youtube videos about surrealdb, by Beyond Fireship and Coders Page