{"action":"created","issue":{"url":"https://api.github.com/repos/Octopoos/SEBLOD/issues/82","labels_url":"https://api.github.com/repos/Octopoos/SEBLOD/issues/82/labels{/name}","comments_url":"https://api.github.com/repos/Octopoos/SEBLOD/issues/82/comments","events_url":"https://api.github.com/repos/Octopoos/SEBLOD/issues/82/events","html_url":"https://github.com/Octopoos/SEBLOD/issues/82","id":95648309,"number":82,"title":"Checkbox Dynamic: $user doesn't work (SQL error)","user":{"login":"pierre-H","id":6079305,"avatar_url":"https://avatars.githubusercontent.com/u/6079305?v=3","gravatar_id":"","url":"https://api.github.com/users/pierre-H","html_url":"https://github.com/pierre-H","followers_url":"https://api.github.com/users/pierre-H/followers","following_url":"https://api.github.com/users/pierre-H/following{/other_user}","gists_url":"https://api.github.com/users/pierre-H/gists{/gist_id}","starred_url":"https://api.github.com/users/pierre-H/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pierre-H/subscriptions","organizations_url":"https://api.github.com/users/pierre-H/orgs","repos_url":"https://api.github.com/users/pierre-H/repos","events_url":"https://api.github.com/users/pierre-H/events{/privacy}","received_events_url":"https://api.github.com/users/pierre-H/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-07-17T12:34:31Z","updated_at":"2015-08-11T10:32:49Z","closed_at":"2015-08-11T10:32:49Z","body":"Hi,\r\nThank you for Seblod : it's a great tool !\r\nI setup a checkbox dynamic field (v. 1.0.0) which select title and id of usergroups according to an user propriety. So I 'Where' I put : parent_id = $user->  *something*. With **Select dynamic** it's working but not with **Checkbox dynamic** : i've got in the form an SQL error : ``SELECT title AS text, id AS value FROM #__usergroups WHERE parent_id= $user->something`` so it doesn't evaluate the expression $user->something.\r\n\r\nThe only solution is to use the free method and write the sql line : ``SELECT title AS text, id AS value FROM #__usergroups WHERE parent_id= $user->something``.\r\n\r\nThank you in advance for the fix !"},"comment":{"url":"https://api.github.com/repos/Octopoos/SEBLOD/issues/comments/129826544","html_url":"https://github.com/Octopoos/SEBLOD/issues/82#issuecomment-129826544","issue_url":"https://api.github.com/repos/Octopoos/SEBLOD/issues/82","id":129826544,"user":{"login":"sebastienheraud","id":1101317,"avatar_url":"https://avatars.githubusercontent.com/u/1101317?v=3","gravatar_id":"","url":"https://api.github.com/users/sebastienheraud","html_url":"https://github.com/sebastienheraud","followers_url":"https://api.github.com/users/sebastienheraud/followers","following_url":"https://api.github.com/users/sebastienheraud/following{/other_user}","gists_url":"https://api.github.com/users/sebastienheraud/gists{/gist_id}","starred_url":"https://api.github.com/users/sebastienheraud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sebastienheraud/subscriptions","organizations_url":"https://api.github.com/users/sebastienheraud/orgs","repos_url":"https://api.github.com/users/sebastienheraud/repos","events_url":"https://api.github.com/users/sebastienheraud/events{/privacy}","received_events_url":"https://api.github.com/users/sebastienheraud/received_events","type":"User","site_admin":false},"created_at":"2015-08-11T10:32:49Z","updated_at":"2015-08-11T10:32:49Z","body":"Hi Pierre-H,\r\nDynamic Checkbox 1.2.0 release is available. It includes your fix.\r\nThank you.\r\nSaba."}}