{"action":"created","issue":{"url":"https://api.github.com/repos/o5/grido/issues/249","labels_url":"https://api.github.com/repos/o5/grido/issues/249/labels{/name}","comments_url":"https://api.github.com/repos/o5/grido/issues/249/comments","events_url":"https://api.github.com/repos/o5/grido/issues/249/events","html_url":"https://github.com/o5/grido/issues/249","id":121914858,"number":249,"title":"Sort replacement column \"bug\"","user":{"login":"misaon","id":15806356,"avatar_url":"https://avatars.githubusercontent.com/u/15806356?v=3","gravatar_id":"","url":"https://api.github.com/users/misaon","html_url":"https://github.com/misaon","followers_url":"https://api.github.com/users/misaon/followers","following_url":"https://api.github.com/users/misaon/following{/other_user}","gists_url":"https://api.github.com/users/misaon/gists{/gist_id}","starred_url":"https://api.github.com/users/misaon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/misaon/subscriptions","organizations_url":"https://api.github.com/users/misaon/orgs","repos_url":"https://api.github.com/users/misaon/repos","events_url":"https://api.github.com/users/misaon/events{/privacy}","received_events_url":"https://api.github.com/users/misaon/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/o5/grido/labels/DISCUSSION","name":"DISCUSSION","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-13T11:45:00Z","updated_at":"2015-12-14T13:51:29Z","closed_at":null,"body":"Mám dotaz,\r\nkdyž máš tabulky **domény** a **zákazníci**. U tabulky domény si vypisuji další informace jako např.: datum expirace, dostupnost... a mimo jiné i jméno zákazníka. To mám propojené s tabulkou zákazníci pomocí ID zákazníka. Potom v tabulce domén toto ID zákazníka přepisuji pomocí funkce **setReplacement**. Problém nastává v okamžiku filtraci a řazení. Stále se jména zákazníků v tabulce domén řadí podle onoho ID a ne podle přepsaného jména. Proto filtrace ani řazení nefungují \"správně\". Je nějaká jiná cesta jak tohle řešit?"},"comment":{"url":"https://api.github.com/repos/o5/grido/issues/comments/164443112","html_url":"https://github.com/o5/grido/issues/249#issuecomment-164443112","issue_url":"https://api.github.com/repos/o5/grido/issues/249","id":164443112,"user":{"login":"o5","id":218562,"avatar_url":"https://avatars.githubusercontent.com/u/218562?v=3","gravatar_id":"","url":"https://api.github.com/users/o5","html_url":"https://github.com/o5","followers_url":"https://api.github.com/users/o5/followers","following_url":"https://api.github.com/users/o5/following{/other_user}","gists_url":"https://api.github.com/users/o5/gists{/gist_id}","starred_url":"https://api.github.com/users/o5/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/o5/subscriptions","organizations_url":"https://api.github.com/users/o5/orgs","repos_url":"https://api.github.com/users/o5/repos","events_url":"https://api.github.com/users/o5/events{/privacy}","received_events_url":"https://api.github.com/users/o5/received_events","type":"User","site_admin":false},"created_at":"2015-12-14T13:51:29Z","updated_at":"2015-12-14T13:51:29Z","body":"Pokud je to klasický join 1:1, tak si namapuj název sloupce/filtru na najoinovaný sloupec. V tvém případě něco jako:\r\n\r\nSQL v modelu co nastavuješ Gridu.\r\n```sql\r\nSELECT d.*, z.jmeno as zakaznik\r\nFROM domeny d\r\nLEFT JOIN zakaznici z ON (d.zakaznik_id = z.id)\r\n```\r\n\r\nDefinice sloupce\r\n```php\r\n$grid->addColumn('zakaznik', 'Zakaznik')\r\n```"}}