laravel-api-handler icon indicating copy to clipboard operation
laravel-api-handler copied to clipboard

better if this package support more than two layer "_fields" nesting

Open RichardFans opened this issue 8 years ago • 1 comments
trafficstars

Api like:

http://mba.cn/api/tests/users?_with=class,class.headteacher,nation&nation.id-in=1,2&_fields=class.name,class.headteacher.name

cause:

"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'headteacher.name' in 'field list' (SQL: select `name`, `headteacher`.`name`, `id`, `headteacher_id` from `mba_classes` where `mba_classes`.`id` in (1))"

RichardFans avatar Apr 09 '17 01:04 RichardFans

Through more tests that I found the right way:

http://mba.cn/api/tests/users?_with=class,class.headteacher,nation&nation.id-in=1,2&_fields=class.name,headteacher.name

the package is nice !

but how to do if nesting relations has the same name? something like:

?_with=foo.boo.foo&_fields=foo.name

RichardFans avatar Apr 09 '17 01:04 RichardFans