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 <eradwan1...@gmail.com> 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