Re: [Dolibarr-dev] Question about files uploaded for expensereport

2019-07-28 Par sujet Laurent Destailleur (aka Eldy)
The goal of field src_object_id is to be able, in a future, to get list of all files with a sql request instead of a directory scan. However, for the moment, the field is filled only when files is "generated", not when it is "uploaded" So you can't use it yet. Solution is like you do SELECT filena

[Dolibarr-dev] Question about files uploaded for expensereport

2019-07-26 Par sujet Eric Seigne via Dolibarr-dev
Hello dev, i was looking for a SQL request to get all files connected to a expense report ... something like that (for example if my expense report is id=2) SELECT * FROM `llx_ecm_files` WHERE `src_object_id` = 2 and src_object_type='expensereport' This request send me some informations but not