extra Invoice line

Using my Dolibarr
1

Hi,

In delibarr I have created an new extra invoice line ( colum ), this create an new colum in the database on the table llx_facturedet_extrafields.
But how do I use it with creating a new invoice via the Rest API.

Also if I query for the invoice I don’t see this value back in an variable, is it possible via the api?

Kind regards,

2

I see that in the contract module, this extra value comes out in the api as an array in array_options. In the API you can search for as an sqlfilter, but this is in a separate table so howto query for it?

3

In the sqlfilters you can write in a full-blown subquery. Example:

( t.rowid IN ( SELECT value_you_want FROM table_you_want ) )

I’m not really advocating that this is the way to do it. I’m just offering an alternative. because I fear the decrease in speed performance.

4

can you provide an example of how to use this?