{"action":"created","issue":{"url":"https://api.github.com/repos/airmoi/FileMaker/issues/11","repository_url":"https://api.github.com/repos/airmoi/FileMaker","labels_url":"https://api.github.com/repos/airmoi/FileMaker/issues/11/labels{/name}","comments_url":"https://api.github.com/repos/airmoi/FileMaker/issues/11/comments","events_url":"https://api.github.com/repos/airmoi/FileMaker/issues/11/events","html_url":"https://github.com/airmoi/FileMaker/issues/11","id":214581094,"number":11,"title":"Sorting after find not working","user":{"login":"steveAllen0112","id":474758,"avatar_url":"https://avatars1.githubusercontent.com/u/474758?v=3","gravatar_id":"","url":"https://api.github.com/users/steveAllen0112","html_url":"https://github.com/steveAllen0112","followers_url":"https://api.github.com/users/steveAllen0112/followers","following_url":"https://api.github.com/users/steveAllen0112/following{/other_user}","gists_url":"https://api.github.com/users/steveAllen0112/gists{/gist_id}","starred_url":"https://api.github.com/users/steveAllen0112/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/steveAllen0112/subscriptions","organizations_url":"https://api.github.com/users/steveAllen0112/orgs","repos_url":"https://api.github.com/users/steveAllen0112/repos","events_url":"https://api.github.com/users/steveAllen0112/events{/privacy}","received_events_url":"https://api.github.com/users/steveAllen0112/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-03-16T02:25:38Z","updated_at":"2017-03-16T17:12:07Z","closed_at":null,"body":"Used\r\n\r\n`$q = $db ->newFindCommand('layoutname');`\r\n`$q -> addFindCriterion('field','value');`\r\n`$q -> addSortRule('field',1,FILEMAKER_SORT_DESCEND);`\r\n\r\n`$r = $q -> execute();`\r\n\r\nIt throws a 108, \"Value list is missing\" error.  Commenting out the sort lines, it doesn't throw the error.  Trace shows error thrown at the execute().\r\n\r\nOne of the sort fields (I have three sort lines) has a value list on it, but even when I remove that one from the sort, and even take it off the field on the layout (set the field back to \"Edit box\" instead of \"Drop-down list\"), so that none of the sorts have value lists, the error is still thrown."},"comment":{"url":"https://api.github.com/repos/airmoi/FileMaker/issues/comments/287127037","html_url":"https://github.com/airmoi/FileMaker/issues/11#issuecomment-287127037","issue_url":"https://api.github.com/repos/airmoi/FileMaker/issues/11","id":287127037,"user":{"login":"airmoi","id":2822333,"avatar_url":"https://avatars1.githubusercontent.com/u/2822333?v=3","gravatar_id":"","url":"https://api.github.com/users/airmoi","html_url":"https://github.com/airmoi","followers_url":"https://api.github.com/users/airmoi/followers","following_url":"https://api.github.com/users/airmoi/following{/other_user}","gists_url":"https://api.github.com/users/airmoi/gists{/gist_id}","starred_url":"https://api.github.com/users/airmoi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/airmoi/subscriptions","organizations_url":"https://api.github.com/users/airmoi/orgs","repos_url":"https://api.github.com/users/airmoi/repos","events_url":"https://api.github.com/users/airmoi/events{/privacy}","received_events_url":"https://api.github.com/users/airmoi/received_events","type":"User","site_admin":false},"created_at":"2017-03-16T17:12:07Z","updated_at":"2017-03-16T17:12:07Z","body":"Hi Steven, I wasn't able to reproduce the issue.\r\nCan you send me a sample file ?\r\n\r\nAlso, do you have any \"validation\" rule on those fields which requires a value list that could be not accessed over php (i.e no view privilege)"}}
{"actor":{"display_login":"airmoi"}}