As reported at the time, the docs are again not accessible.
OK. I have found my mistake.
i sort by a column that is in the table but not in the select-statement.
E.g.
SQL
SELECT col1, col2, col3, col8, col9 WHERE col8=1234 ORDER BY col11 DESC;
this is not working with toolbar search, since the system build the following query:
SQL
SELECT * FROM ( SELECT col1, col2, col3, col8, col9 WHERE col8=1234 ORDER BY col11 DESC) gridsearch WHERE (col1 LIKE ?) ORDER BY col11 desc LIMIT 0, 100
Sounds promising.
Thanks for the answer.
Ahh.
The links are copied from the page you suggest.
Now the links work again.
i will answer myself 😀
use the colmodel option “fixed” => true.
that is it. Thanks for fast response.
PHP 7.1.9.
so should look like: https://s14.postimg.org/sbasm41fl/screenshot2.png
the classic german notation dd.mm.yyyy.
the format is right in the pdf but the date itself is wrong.
OK. But it doesnt work for me. See Screenshot https://s14.postimg.org/tpyl5z8rl/screenshot.png
Thanks. That works fine.
But the date fields are still in wrong format if i export to pdf.
i will try to explain better.
i have an column with an date in my grid with the following code:
1 2 3 4 5 6 7 8 9 10 11 12 |
$grid->setUserDate("Y-m-d"); $grid->setUserTime("Y-m-d"); $grid->datearray = array("terminVon"); $grid->setColProperty('terminID', [ 'label' => 'ID', 'hidden' => true, 'width' => 40, "colmenu" => false, 'editoptions' => [ 'readonly' => true] ]); |
All data is stored in in mysql database. the col with the date ist stored as the standard mysql type ‘date’.
All work fine so far. the date appears as YYYY-MM-DD, the html inputfield (type=”date”) use this format and the database use this format also. But in Germany we have DD.MM.YYYY as notation for date.
So I just want to format the date for the output in the grid in german notation. Otherwise, both in the editform and in the database the date format should be used “raw”.
I hope despite my bad English, I could explain my request.
OK.
Is an exact date for release known?
exacly. i have to format the grid and form edit field diffrently. to be precise, I would like to format a field in the grid and unformated it in the form field.
Thanks.
is there an method in php?
Works fine. thx
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top