December 10 2017, 20:10

For friends about #hybris: Sharing useful Groovy scripts that I frequently use at work. Today I am sharing my script for creating a database query, where you only input the type, and it does everything else by itself: joins related tables, selects a list of attributes, etc. In Hybris, atop the database, there is a special ORM layer where the database table analog is “itemtype”. So, to extract all the useful data (for reconciliation purposes, for example), you need to write a bulky query. To make it easier to write, here I’ve drafted a little script that generates it. You can find usage examples via the link.

https://hybrismart.com/2017/12/08/useful-groovy-scripts-flexible-search-query-generator-for-any-type/

Leave a comment