You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Barou <ZS...@gmail.com> on 2015/09/08 14:55:37 UTC
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-model-tp4671933.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: New question how can I get the Entity model
Posted by Ron Wheeler <rw...@artifact-software.com>.
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: rwheeler@artifact-software.com
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
Re: New question how can I get the Entity model
Posted by Jean-Luc Sylvestre <je...@novitek.dk>.
Thank you
On Tue, Sep 8, 2015 at 5:05 PM, Peter Arnold <pa...@paec.cl> wrote:
> 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:ZSBarou@gmail.com]
> Enviado el: martes, 08 de septiembre de 2015 8:56
> Para: user@ofbiz.apache.org
> 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
>
>
RE: New question how can I get the Entity model
Posted by Peter Arnold <pa...@paec.cl>.
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:ZSBarou@gmail.com]
Enviado el: martes, 08 de septiembre de 2015 8:56
Para: user@ofbiz.apache.org
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