Extrafields type of "case à cocher" and "case à cocher issue d'une table" not there V20.0.1

[TechServiceConseil]

Bug

The two type in the title vanish. when you want to create a extrafields. I don't know if it was the case in V20

It seems the types are present in the funvtion of extrafields class but i don't get how the view works

Dolibarr Version

No response

Environment PHP

No response

Environment Database

No response

Steps to reproduce the behavior and expected behavior

No response

Attached files

No response

[ksar-ksar]

Hello,

Are you speaking about that ?

It is availlable on a V20.0.1

[TechServiceConseil]

Hello,

No i talk about this one

[TechServiceConseil]

Ok it's this one. I try it with a simple one. The synthax change. Have you a idea about what change? The synthax before work in V19.0.2

Best regards !

[TechServiceConseil]

Hello,

I investigate and try some stuff but nothing works. It's maybe related to #31253
But i need to acces to another table and there is not precision about that.
So in the new synthax, how the FROM of the IN is handle?

My error message it's almost the same:
Error in request SELECT rowid as rowid, label FROM mqrc_product WHERE Filter error - Bad syntax of the search string ORDER BY label You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'error - Bad syntax of the search string ORDER BY label' at line 1. Check setup of extra parameters.

i have try :
product:label:rowid::(rowid:in:(SELECT fk_product FROM llx_categorie_product WHERE fk_categorie = 1))

Thx

[ksar-ksar]

Ok then the type is OK, it's only the extrafied syntax that you are looking for.
If you need help, please visit dolibarr forum.
GitHub is for Bugs declaration.