{"issue":{"created_at":"2011-11-28T16:46:11Z","state":"open","updated_at":"2011-11-28T16:46:12Z","user":{"gravatar_id":"e80c46e273aeef40f4fee102a03522cf","id":676671,"url":"https://api.github.com/users/computino","avatar_url":"https://secure.gravatar.com/avatar/e80c46e273aeef40f4fee102a03522cf?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"computino"},"comments":1,"body":"Ich habe gerade probiert im \"list_fields\" Feld bei der Auflistung einen nested select zu nutzen. Inhalt war:\n\n```\ntl_news_archive.id, tl_news_archive.title, (SELECT COUNT(*) FROM tl_news WHERE pid = tl_news_archive.id) as count_news\n```\n\nSinn ist klar, ähnliche Einsatzmöglichkeiten fallen mir gleich dutzende ein - ich bin nur gerade erst auf die Idee mit dem nested select gekommen ;)\n\nProblem: die Klammern werden in HTML-Entities decodiert. Daran ändert weder ein \"allowHTML\" noch ein \"decodeEntities\". Resultierender Code ist dann:\n\n```\ntl_news_archive.id, tl_news_archive.title, &#40;SELECT COUNT&#40;*&#41; FROM tl_news WHERE pid &#61; tl_news_archive.id&#41; as count_news\n```\n\nEntweder das ist ein Bug, dass weder \"allowHTML\" noch \"decodeEntities\" wirken, oder es würde folgendes Abhilfe schaffen:\n\n```\nModuleListing.php ~ 147\n$strQuery = \"SELECT \" . html_entity_decode($this->list_fields) . \" FROM \" . $this->list_table;\n```\n\n--- _Originally created on January 12th, 2009, at 02:05am (ID 409)_","assignee":{"gravatar_id":"87d2e5aefadcb310f9155df28c2b3582","id":1192057,"url":"https://api.github.com/users/leofeyer","avatar_url":"https://secure.gravatar.com/avatar/87d2e5aefadcb310f9155df28c2b3582?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"leofeyer"},"id":2369714,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"number":409,"labels":[{"name":"Feature","color":"4183c4","url":"https://api.github.com/repos/contao/test/labels/Feature"},{"name":"listing","color":"e6e6e6","url":"https://api.github.com/repos/contao/test/labels/listing"}],"title":"Auflistung mit erweiterten Abragen braucht HTML-Decode","closed_at":null,"html_url":"https://github.com/contao/test/issues/409","url":"https://api.github.com/repos/contao/test/issues/409","milestone":{"created_at":"2011-11-28T15:58:43Z","state":"open","closed_issues":27,"due_on":null,"creator":{"gravatar_id":"87d2e5aefadcb310f9155df28c2b3582","id":1192057,"url":"https://api.github.com/users/leofeyer","avatar_url":"https://secure.gravatar.com/avatar/87d2e5aefadcb310f9155df28c2b3582?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"leofeyer"},"number":6,"description":"TYPOlight 2.6.4 (maintenance release)","title":"2.6.4","open_issues":1,"url":"https://api.github.com/repos/contao/test/milestones/6"}},"action":"created","comment":{"created_at":"2011-11-28T16:46:12Z","updated_at":"2011-11-28T16:46:12Z","user":{"gravatar_id":"87d2e5aefadcb310f9155df28c2b3582","id":1192057,"url":"https://api.github.com/users/leofeyer","avatar_url":"https://secure.gravatar.com/avatar/87d2e5aefadcb310f9155df28c2b3582?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"leofeyer"},"body":"Funktioniert denn die Unterabfrage nach dem Patch bei Dir? Eigentlich dürfte das gar nicht gehen, denn die Programmlogik erwartet ja Felder aus nur einer Tabelle. Was passiert mit einem solchen Feld in der Detailansicht oder bei der Suche/Sortierung?\n\n--- _Originally created on January 12th, 2009, at 09:58am_","id":2900913,"url":"https://api.github.com/repos/contao/test/issues/comments/2900913"}}