Excellent suggestion. Many thanks, Giulio. Best Regards,
Emad > On 12 Feb 2022, at 3:13 PM, Giulio Speri - MpStyle Srl > <[email protected]> wrote: > > Hello Emad, > > To perform that kind of check, you'll find a useful tool in the Webtools > backoffice application, named *Entity Engine*. > Once in the Webtools, you'll find the *EntityEngine* menu voice and from > there different kinds of operations can be performed through specific > Tabs. > IMO the two most useful tools are *Entity Data Maintenance* and *Entity SQL > Processor*. > The *Entity Data Maintenance* lists all the entities and view entities in > the ofbiz db, and you can search for records in a specific table: with this > tool you should be able to do the "related" search you desire. In fact, for > example, if you search for the table Party and the PK "10000", the entity > engine will show you obviously that record, but also it lists in a > drop-down element all the related entities and view-entities (ie: > PartyRole, PartyContactMech,...) letting the user explore related data. > This is a fast way to check all the values and entities related to a table. > > The *Entity SQL Processor* is a tool with which you can perform SQL queries > to the db. > > I hope I've been helpful. > > Best regards, > Giulio > > On Sat, Feb 12, 2022, 13:19 Emad Radwan <[email protected]> wrote: > >> Hello Community, >> >> Part of my strategy in understanding Ofbiz internal design is by >> inspecting values created in the DB, I do that by searching for values that >> I enter in Ofbiz GUI and trying to find what different tables contain such >> values. >> >> When the Primary key value for a certain entity - Party for example - is >> open for data entry such as in the ‘Create Customer’ screen, it’ll be easy >> for me to achieve the above. On the other hand, in tables that the primary >> key is filled internally by a ‘sequence number’ that wouldn’t be possible. >> >> My question here is, is there a way to control what kind of value is being >> inserted in such PK fields so I can find in my DB search all related tabes >> that was used while creating a certain transaction from the GUI? >> >> Regards, >> >> Emad
