{"action":"opened","issue":{"url":"https://api.github.com/repos/molgenis/molgenis/issues/4873","repository_url":"https://api.github.com/repos/molgenis/molgenis","labels_url":"https://api.github.com/repos/molgenis/molgenis/issues/4873/labels{/name}","comments_url":"https://api.github.com/repos/molgenis/molgenis/issues/4873/comments","events_url":"https://api.github.com/repos/molgenis/molgenis/issues/4873/events","html_url":"https://github.com/molgenis/molgenis/issues/4873","id":155448017,"number":4873,"title":"Sorting on computed attributes in table exception","user":{"login":"dennishendriksen","id":2477186,"avatar_url":"https://avatars.githubusercontent.com/u/2477186?v=3","gravatar_id":"","url":"https://api.github.com/users/dennishendriksen","html_url":"https://github.com/dennishendriksen","followers_url":"https://api.github.com/users/dennishendriksen/followers","following_url":"https://api.github.com/users/dennishendriksen/following{/other_user}","gists_url":"https://api.github.com/users/dennishendriksen/gists{/gist_id}","starred_url":"https://api.github.com/users/dennishendriksen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dennishendriksen/subscriptions","organizations_url":"https://api.github.com/users/dennishendriksen/orgs","repos_url":"https://api.github.com/users/dennishendriksen/repos","events_url":"https://api.github.com/users/dennishendriksen/events{/privacy}","received_events_url":"https://api.github.com/users/dennishendriksen/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/molgenis/molgenis/labels/1.21.0-RC","name":"1.21.0-RC","color":"fbca04"},{"url":"https://api.github.com/repos/molgenis/molgenis/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/molgenis/molgenis/labels/molgenis-dataexplorer","name":"molgenis-dataexplorer","color":"009900"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-05-18T08:50:30Z","updated_at":"2016-05-18T08:50:30Z","closed_at":null,"body":"#### Reproduce\r\n- Import \r\n[emx_all_datatypes.xlsx](https://github.com/molgenis/molgenis/files/270012/emx_all_datatypes.xlsx)\r\n- Open TypeTest entity in Data explorer plugin\r\n- Select 'xcomputedint label' header in table\r\n\r\n#### Expected\r\n- Table sorted ascending on 'xcomputedint label'\r\n\r\n#### Observed\r\n- ```Error! PreparedStatementCallback; bad SQL grammar [SELECT this.`id`, this.`xbool`, this.`xboolnillable`, this.`xcategorical_value`, this.`xcategoricalnillable_value`, (SELECT GROUP_CONCAT(DISTINCT(`xcategoricalmref_value`.`xcategoricalmref_value`) ORDER BY `xcategoricalmref_value`.`order`) FROM `org_molgenis_test_TypeTest_xcategoricalmref_value` AS `xcategoricalmref_value` WHERE (this.`id` = `xcategoricalmref_value`.`id`) ) AS `xcategoricalmref_value`, (SELECT GROUP_CONCAT(DISTINCT(`xcatmrefnillable_value`.`xcatmrefnillable_value`) ORDER BY `xcatmrefnillable_value`.`order`) FROM `org_molgenis_test_TypeTest_xcatmrefnillable_value` AS `xcatmrefnillable_value` WHERE (this.`id` = `xcatmrefnillable_value`.`id`) ) AS `xcatmrefnillable_value`, this.`xdate`, this.`xdatenillable`, this.`xdatetime`, this.`xdatetimenillable`, this.`xdecimal`, this.`xdecimalnillable`, this.`xemail`, this.`xemailnillable`, this.`xenum`, this.`xenumnillable`, this.`xhtml`, this.`xhtmlnillable`, this.`xhyperlink`, this.`xhyperlinknillable`, this.`xint`, this.`xintnillable`, this.`xintrange`, this.`xintrangenillable`, this.`xlong`, this.`xlongnillable`, this.`xlongrange`, this.`xlongrangenillable`, (SELECT GROUP_CONCAT(DISTINCT(`xmref_value`.`xmref_value`) ORDER BY `xmref_value`.`order`) FROM `org_molgenis_test_TypeTest_xmref_value` AS `xmref_value` WHERE (this.`id` = `xmref_value`.`id`) ) AS `xmref_value`, (SELECT GROUP_CONCAT(DISTINCT(`xmrefnillable_value`.`xmrefnillable_value`) ORDER BY `xmrefnillable_value`.`order`) FROM `org_molgenis_test_TypeTest_xmrefnillable_value` AS `xmrefnillable_value` WHERE (this.`id` = `xmrefnillable_value`.`id`) ) AS `xmrefnillable_value`, this.`xstring`, this.`xstringnillable`, this.`xtext`, this.`xtextnillable`, this.`xxref_value`, this.`xxrefnillable_value`, this.`xstring_hidden`, this.`xstringnillable_hidden`, this.`xstring_unique`, this.`xint_unique`, this.`xxref_unique` FROM `org_molgenis_test_TypeTest` AS this GROUP BY this.`id`, this.`xbool`, this.`xboolnillable`, this.`xcategorical_value`, this.`xcategoricalnillable_value`, this.`xdate`, this.`xdatenillable`, this.`xdatetime`, this.`xdatetimenillable`, this.`xdecimal`, this.`xdecimalnillable`, this.`xemail`, this.`xemailnillable`, this.`xenum`, this.`xenumnillable`, this.`xhtml`, this.`xhtmlnillable`, this.`xhyperlink`, this.`xhyperlinknillable`, this.`xint`, this.`xintnillable`, this.`xintrange`, this.`xintrangenillable`, this.`xlong`, this.`xlongnillable`, this.`xlongrange`, this.`xlongrangenillable`, this.`xstring`, this.`xstringnillable`, this.`xtext`, this.`xtextnillable`, this.`xxref_value`, this.`xxrefnillable_value`, this.`xstring_hidden`, this.`xstringnillable_hidden`, this.`xstring_unique`, this.`xint_unique`, this.`xxref_unique` ORDER BY `xcomputedint` ASC LIMIT 20]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'xcomputedint' in 'order clause'```"}}