QLSTATE[42S22]: Column not found: 1054 Unknown column 'testcase.testdaten' in 'field list'",
....
"args": [
"SELECT `testcase`.`id` AS `id`, `testcase`.`name` AS `name`, `testcase`.`testdaten` AS `testdaten`, `testcase`.`json` AS `json`, `testcase`.`angelegt` AS `angelegt` FROM `testcase` LIMIT 10 OFFSET 0"
Any Idea to get custom column in enterprise?
best gregards
rené
PS
the old code is 1.x on ci3
the new 2.x enterprise on ci4
Funny enough, without knowing that you just asked this question about a custom extra column some hours ago, I wrote an email to John asking exactly this. Still waiting for response. But looking forward in solving this issue.
First of all welcome @obiwanke and @xyz to our forums . Ok, there is actually a frustration and I can explain (and at the end also give a solution).
Grocery CRUD datagrid work primarily with complicated database queries. So any field should unfortunately be in the database or create a custom Model to manipulate that. However as I can understand that it is a bit of non-sense to create a custom Model only for that there is an undocumented (that I will document soon) work-around for that.
There is a function with name “mapColumn” in order to map a field with another one. Actually I will give an example to be more clear. Let’s say that we have a new field name “whatever”. As the “whatever” field doesn’t exist we need to map it with another field, let’s say “email”. This will look like this:
$crud->columns(['customer_name','test_choices', 'country', 'email', 'whatever']);
$crud->fieldTypeColumn('whatever', 'varchar');
$crud->mapColumn('whatever', 'email');
$crud->callbackColumn('whatever', function ($value) {
// The $value here is the 'email' value
return "<div style='background:red'>$value</div>";
});
Keep in mind that if you use a field only on column it is better to use fieldTypeColumn instead of fieldType as it is specified only for the initial datagrid.
Last but not least, I am keeping a note to create a new field type with name “fake” to solve this issue without a work-around in the future.
thanks for this work-around. It works as described.
It’s doing it by now, but the problem is, you always have to put all column names in the array of the $crud-columns call to get this extra “whatever” column. At the moment I had no $crud->columns method call, but with this work-araound I have to enumerate all the names of all the columns in the table.
Anyway, thanks
Regards
Obiwanke
I’ve kept a note so I can include the “fake” field type but I can’t promise any dates for that so till then you can use a helper function for Codeigniter 4. For example, you can use a helper that will look like this:
function getAllDatabaseColumns($tableName) {
// Code for Codeigniter 4
$db = db_connect();
$query = $db->query('SHOW FIELDS FROM `' . $tableName . '`');
$result = $query->getResult();
$columnNames = [];
foreach ($result as $row) {
$columnNames[] = $row->Field;
}
return $columnNames;
};
And you can simply get all the columnNames by using:
getAllDatabaseColumns('yourTableName')
If you would also like to add the extra columns you can use the array_merge of PHP. So at the above example this will look like this:
Also keep in mind that I always recommend to use your common functions into one place. For example, if you would like to have an extra column with all the fields, you can always have a function like this:
function groceryCRUDAddExtraColumn($crud, $columnName) {
$crud->fieldTypeColumn($columnName, 'varchar');
$crud->mapColumn($columnName, 'id');
}
Funny enough, without knowing that you just asked this question about a custom extra column some hours ago, I wrote an email to John asking exactly this. Still waiting for response. But looking forward in solving this issue.
. Ok, there is actually a frustration and I can explain (and at the end also give a solution).
