-
Notifications
You must be signed in to change notification settings - Fork 27
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
Question: ASUM in Many-to-Many relationship #14
Comments
I'm afraid it's not possible for now because ASUM can only handle second-level relational fields while your case is third-level. Fortunately, it's not hard to solve so if I have time, I will look into it. |
Hi @duydvu , thanks for replying. If you can explain what I need to do I'll code it. Thank you again. |
Contributions are appreciated. You will need to specify which fields need to be queried in utils.ts. Currently, no fields are specified in the query so Directus will return only top-level values (see here). If you know which fields are used in the template (require parsing it), then you can place them into the query and Directus will automatically return their values. About how to parse the template, I'm using a simple parsing algorithm - find a pair of Good luck! |
Hello folks, I have a question that I can't solve by myself.
I have a many-to-many relatioship as below:
products
orders
orders_products
I have a doubt how I can write a syntax to compute the field like this sql query:
My goal is, when I add the product should calculate the total of order.
The text was updated successfully, but these errors were encountered: