SQL Searches for advanced users


Another point is to add "sql searches" to the list of the searches the user can choose of. That means I can a) do my own searches using the "find window", b) use searches from a power user that shared them with me and c) use very specific and powerful searches that the implementor did in sql

Reference: http://wiki.idempiere.org/en/IDempiere_workshop_2015/transcript#saved_searches




Diego Ruiz
November 21, 2019, 9:44 PM

Thank you ,


In the original migration script, I did what you say of updating the field and checking centrally mantained = 'N', but only on the new User Queries window. I updated a new patch removing the change in AD_Column and adding the change in the field in the User → Queries tab.



Diego Ruiz

Norbert Bede
November 22, 2019, 12:17 PM

can you share how GUI changes ? how this influence enduser work ? n

Diego Ruiz
November 22, 2019, 12:28 PM



The GUI changes are the same as the ones from , this ticket just extends those changes to allow the advanced users to create more powerful queries with SQL .


BTW: Regarding your comment on about a default user query, I will create a new ticket for that improvement.

Best regards,

Diego Ruiz

Norbert Bede
December 9, 2019, 7:17 PM

- We are used the follow plugin in sugarcrm some years ago - really good concept - you can take a look for motivation. http://www.dispage.com/wiki/Custom_Query

Diego Ruiz
December 19, 2019, 11:21 AM


Diego Ruiz


Diego Ruiz

Tested By