Relations FK

[pawelpodkowa]

Hi,

got:

ALTER TABLE `survey`
  ADD CONSTRAINT `survey_ibfk_1` FOREIGN KEY (`status`) REFERENCES `survey_status_names` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Ograniczenia dla tabeli `survey_users`
--
ALTER TABLE `survey_users`
  ADD CONSTRAINT `survey_users_ibfk_1` FOREIGN KEY (`survey_id`) REFERENCES `survey` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `survey_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `survey_users_ibfk_3` FOREIGN KEY (`survey_access_names_id`) REFERENCES `survey_access_names` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Ograniczenia dla tabeli `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `access_name` FOREIGN KEY (`access_level`) REFERENCES `access_names` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
COMMIT;

And i do:
/users?include=survey,survey_access_names,survey_status_names&exclude=password&filter=id,eq,'.$id.''

my callback is:
null

if i do:
/users?include=survey,survey_status_names&exclude=password&filter=id,eq,'.$id.''

that works,
and problem is that when i use survey_access_names i should get an array survey_access_names_id which got object with access_survey_names (string). I understand that the status is inside the survey table so that FK works properly, but why if i link with fk id from survey_access_names_id from survey_users that not contain linked table, like: survey_access_names as array of survey_access_names_id

this is the not supporten multi fk ? sry for my english, please help with this.

[pawelpodkowa]

everytime when i use survey_access_names in include, the callback is null

[pawelpodkowa]

[mevdschee]

Thank you for submitting this issue and the details about your setup. The code does support multiple foreign keys... are there any errors in the log? When your remove "transform=1" do you get the right results?

[pawelpodkowa]

no, without &transform=1 i got everytime "data is null". Even when i do simple: users?include=access_names,survey = null
users?include=access_names,survey,survey_status_names,survey_access_names = null

with transform=1 works fine, but not contain survey_access_names, its funny becouse when i use users?include=access_names,survey,survey_status_names&transform=1 that works fine, but even when i put survey_access_name i got null, even alone, like:
users?include=access_names,survey,survey_access_names = null
what to do ? did you try do multiple FK ?

[pawelpodkowa]

[pawelpodkowa]

only what i need is array of survey_access_names downthere :P

[pawelpodkowa]

any idea how to resolve that?

[pawelpodkowa]

and why if i remove transform option i got data is null ?

[pawelpodkowa]

@mevdschee any updates? any idea?

[mevdschee]

This should be fixed in v2. Can you confirm?