Complementary attributes: Difference between revisions

m
mNo edit summary
Tag: 2017 source edit
Tag: 2017 source edit
Line 75: Line 75:


===List of suppliers in a Category ===
===List of suppliers in a Category ===
<code>categorie_fournisseur:fk_soc:fk_soc::fk_categorie=10</code>
* On phpmyadmin use the following code <code>SELECT cs.fk_soc, cs.fk_categorie, soc.nom FROM llx_categorie_societe cs inner join llx_societe soc WHERE cs.fk_soc=soc.rowid</code> to create a new "view" that you can name 'llx_mylistcategorie'
* Then on the complementary attribute, use <code>mylistcategorie:nom:fk_soc::fk_categorie=10</code>


== Computed Fields==
== Computed Fields==
676

edits