Using Module Builder to show SQL query results

Hi folks,
I’m a huge fan of Dolibarr and I’m currently trying to tailor it to my specific needs using the module builder.

I want to show two tabs in my module. A “to call” list with third parties with a specific tag and without a “call” event in the last 30 days and (less important) an input mask to easily add new third parties with reduced number of fields.

Usually, I would use a SQL statement (Third party joined by tags and calls I guess) but I struggle to abstract this to the module builder. I tried to make an object but I would need joined tables and not necessarily make a new one.

Tried to check all the documentation I could find but I could not gain the insight I wanted.

I appreciate any help I can get. Thanks in advance! :slight_smile:

1 Like

Hi,
Have you looked into Mylist ? You can find it here: myList : listes dynamiques personnalisées
You can define your own Query and add tabs to screens.