CODEWITHSUNDEEP
selectrelationshipvirtualdreamfactory
marcus n
marcus n

Reputation: 31

How to select fields from related tables in dreamfactory

I am playing with the DreamFactory Schema and API Docs. Within the Schema i add a "Virtual Relationship". Now in API Docs i put the name of the Virtual Relationship in related, on execute everthing is fine. I'll get the fields from the related table. But i dont need all fields from the joined table. How to select only the fields i need? I try to add "name_of_related.field" under "fields".

Error:

"message": "Invalid field requested: fe_users_by_fe_user_id.username"

Upvotes: 0

Views: 282

Answers (1)

marcus n
marcus n

Reputation: 31

add <relation_name>.fields=fieldname1,fieldname2

in my case:

/api/v2/myservice/_table/mytable?fields=uid,tstamp&related=fe_users_by_fe_user_id&fe_users_by_fe_user_id.fields=username

Upvotes: 2

Related Questions