New question how can I get the Entity model

[hoboy1]

CONTENTS DELETED

The author has deleted this message.

[Peter Arnold]

Hi Barou,

What you are looking for is available in OFBiz out of the box.
The related entity is: "CreatedByUserLogin"
Furthermore there is also a relation to entity "LastModifiedByUserLogin"

To investigate the current data model implemented in your version use
WebTools Entity Engine.
Go to the product entity and see for available data and related entities.
With help of the entity engine you can check all relations from and to the
Product entity.
So by verifying with this tool you can be sure if the required relation
exists or not. (Actually it does)

Also in the entity engine you can search for all products created by a
certain user by going to the "Product" entity and then writing the userID
into the field "CreatedByUserLogin" and then hit the FIND button. All
products created by that user are then displayed.

Under the following link you find some diagrams of the data model for rough
orientation.
https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams
Even though these files are not updated they match in most parts.

For further description of the data model you should consider to buy:
The Data Model Resource Book Volume 1 by Len Silverston. See:
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Related+Books


Regards,

Peter

-----Mensaje original-----
De: Barou [mailto:[hidden email]]
Enviado el: martes, 08 de septiembre de 2015 8:56
Para: [hidden email]
Asunto: New question how can I get the Entity model

I have been trying Ofbiz over a week now.
I am looking for the entity model to se the realtion between user-products
tables I want to find the relation from user table to product table if it
exist.
with user login id in my hand I will like to read all the records hi has
created in the product db.




--
View this message in context:
http://ofbiz.135035.n4.nabble.com/New-question-how-can-I-get-the-Entity-mode
l-tp4671933.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
http://www.avast.com

[hoboy2]

CONTENTS DELETED

The author has deleted this message.

[Ron Wheeler]

https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Related+Books
This is a list is books that explain the data model or other aspects of
OFBiz use.
The Data Model books are quite old (2001 and 2009) and do not reflect
the work done over the past few years in OFBiz.
You will also find some articles written by Len Silverston if you do a
bit of searching on Google.
These explain parts of the model.

You best bet is to look at the seed data and the data definitions and
ask questions here.

Your first question sounds like an audit function. You don't really need
a link between users and products, just a way to find out what people
did with products.

Ron

On 08/09/2015 8:55 AM, Barou wrote:

> I have been trying Ofbiz over a week now.
> I am looking for the entity model to se the realtion between user-products
> tables
> I want to find the relation from user table to product table if it exist.
> with user login id in my hand I will like to read all the records hi has
> created in the product db.
>
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/New-question-how-can-I-get-the-Entity-model-tp4671933.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

--
Ron Wheeler
President
Artifact Software Inc
email: [hidden email]
skype: ronaldmwheeler
phone: [phone], ext 102