_log.usu -> _usu.id
$crud->setRelation('usu', '_ usu', 'name');
Posted 09 January 2018 - 09:41 AM
_log.usu -> _usu.id
$crud->setRelation('usu', '_ usu', 'name');
Posted 11 January 2018 - 09:39 AM
$crud = $this->GCRUD_getGroceryCrudEnterprise(); $crud->setTable('_log'); $crud->setSubject("LOG","Registro de LOGS"); $crud->setTheme($this->ciies_model->cfg()["visual_theme"]); $crud->columns(['fec','usu','act','pan','reg']); $crud->fields(['fec','usu','act','pan','reg','txt']); $crud->displayAs('fec','Fecha/Hora'); $crud->displayAs('usu','Usuario'); $crud->displayAs('act','Acción'); $crud->displayAs('pan','Pantalla'); $crud->displayAs('reg','ID de REGISTRO'); $crud->displayAs('txt','Descripción'); $crud->setRelation('usu','_usu','nombre'); $crud->setRead(); $crud->unsetAdd(); $crud->unsetEdit(); $crud->unsetDelete(); $crud->defaultOrdering('fec','desc'); $output = $crud->render();
Posted 11 January 2018 - 02:44 PM
have you tried to change table name from _usu to something else ?
I feel that the similar name of field and table could produce strange behavior.
Try and see if that resolve the issue
Posted 11 January 2018 - 07:17 PM
It was a possibility, but I tried to rename the _usu table by appusers and the result is exactly the same
Posted 05 March 2018 - 10:39 AM
After upgrading to version 2.5.1 the problem has been fixed
Posted 20 June 2018 - 07:10 PM
The set relation in SQL server which returns the similar values but not the exact value so, for that, you can find out the way to follow it after the version updated then from knowing the process is in condition mode instead of that dell printer support will find out the solution for the above query.
Support →
Grocery CRUD Enterprise →
setRelation relational table field column displayStarted by irshadjan, 31 Dec 2020 ![]() |
|
![]() |
||
Support →
I have a question →
set relations between tables in different databases, same "domain", same databases passwordsStarted by fede72bari, 15 May 2020 ![]() |
|
![]() |
||
Support →
Grocery CRUD Enterprise →
Column not found: 1054 Unknown column in where clauseStarted by ajuser, 12 Feb 2020 ![]() |
|
![]() |
||
Support →
Grocery CRUD Enterprise →
Problem with the setRelation dropdown.Started by dhouwen, 04 Feb 2020 ![]() |
|
![]() |
||
Support →
I have a question →
left joinStarted by cpuin, 07 Dec 2019 ![]() |
|
![]() |
0 members, 0 guests, 0 anonymous users