676
edits
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> | * 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== | ||
edits