Dolibarr ERP CRM Wiki

Informations for developpers of complementary modules

Revision as of 09:57, 8 June 2024 by Eric.seigne (talk | contribs) (examples for migration)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Developpers of third part modules MUST consult official dolibarr ChangeLog (section For developers or integrators) and the most important part "WARNING" section.

In that wiki you will find more informations and details about some points. Each developper is invited to contribute on this page with some examples or "good tips" about it.

dolibarr 20

fetchAll and sqlfilters
  • The parameter $filter of method fetchAll does not accept array of SQL but must be a string of an Universal Search Filter syntax.

Old code: 

$SkillrecordsForActiveUser = $sk->fetchAll('ASC', 'fk_skill', 0, 0, array("customsql"=>"fk_object = ".$object->fk_user ." AND objecttype ='".SkillRank::SKILLRANK_TYPE_USER."'"), 'AND');

New code will become 

$SkillrecordsForActiveUser = $sk->fetchAll('ASC', 'fk_skill', 0, 0, "(fk_object:=:".((int) $object->fk_user).") AND (objecttype:=:'".$db->escape(SkillRank::SKILLRANK_TYPE_USER)."')", 'AND');


  • Thanks to fred, other warning about "$db->getRows($sql)"


dolibarr 19

Retrieved from "https://wiki.dolibarr.org/index.php?title=Informations_for_developpers_of_complementary_modules&oldid=60464"