something like that...
I'm sorry but I'm not that good ..
$db = FabrikWorker::getDbo();
$query = $db->getQuery(true);
$query
->select('coalasce(max(numero_pratica),0 +1')
->from($db->quoteName('movimenti'));
$db->setQuery($query);
$count = $db->loadResult();
return $count;
$ formModel-> data ['movimenti___numero_pratica'] = $count;
I'm sorry but I'm not that good ..
$db = FabrikWorker::getDbo();
$query = $db->getQuery(true);
$query
->select('coalasce(max(numero_pratica),0 +1')
->from($db->quoteName('movimenti'));
$db->setQuery($query);
$count = $db->loadResult();
return $count;
$ formModel-> data ['movimenti___numero_pratica'] = $count;