Table Mapping
Locked
 
|
Where is the table mapping?
<#if productAssoc.productId == product.productId> <#assign assocProductId = productAssoc.productIdTo /> <#else> <#assign assocProductId = productAssoc.productId /> </#if> Where to check that productAssoc table is PRODUCT_ASSOC with column PRODUCT_ID? Thanks in advance --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
|
|
I think you are looking for this info: https://localhost:8443/webtools/control/entitymaint https://localhost:8443/webtools/control/FindGeneric?entityName=ProductAssoc&find=true&VIEW_SIZE=50&VIEW_INDEX=0 https://localhost:8443/webtools/control/ViewRelations?entityName=ProductAssoc If not please elaborate your question. Best regards, Pranay Pandey http://www.hotwaxmedia.com On 09-May-2014, at 2:49 PM, Eric Halim wrote: > Where is the table mapping? > > > > <#if productAssoc.productId == product.productId> > > <#assign assocProductId = productAssoc.productIdTo /> > > <#else> > > <#assign assocProductId = productAssoc.productId /> > > </#if> > > > > Where to check that productAssoc table is PRODUCT_ASSOC with column > PRODUCT_ID? > > > > > > Thanks in advance > > > > --- > This email is free from viruses and malware because avast! Antivirus protection is active. > http://www.avast.com |
|
|
Yes, thanks I guess this is it.
Is this equivalent to hibernate.cfg where we define entity and relation among tables? So, if I want to add new table, would it be automatically appear here in this list? Or would there be some special steps to create new table in Ofbiz? Thanks in advance -----Original Message----- From: Pranay Pandey [mailto:[hidden email]] Sent: Monday, May 12, 2014 11:29 AM To: [hidden email] Subject: Re: Table Mapping I think you are looking for this info: https://localhost:8443/webtools/control/entitymaint https://localhost:8443/webtools/control/FindGeneric?entityName=ProductAssoc& find=true&VIEW_SIZE=50&VIEW_INDEX=0 https://localhost:8443/webtools/control/ViewRelations?entityName=ProductAsso c If not please elaborate your question. Best regards, Pranay Pandey http://www.hotwaxmedia.com On 09-May-2014, at 2:49 PM, Eric Halim wrote: > Where is the table mapping? > > > > <#if productAssoc.productId == product.productId> > > <#assign assocProductId = productAssoc.productIdTo /> > > <#else> > > <#assign assocProductId = productAssoc.productId /> > > </#if> > > > > Where to check that productAssoc table is PRODUCT_ASSOC with column > PRODUCT_ID? > > > > > > Thanks in advance > > > > --- > This email is free from viruses and malware because avast! Antivirus > http://www.avast.com --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
|
|
Eric,
You can create the entity (the OFBiz definition of the table) in the appropriate entitymodel.xml and on restart the table will be created in the persistence engine of your choice. Regards, Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Mon, May 12, 2014 at 9:17 AM, Eric Halim <[hidden email]> wrote: > Yes, thanks I guess this is it. > Is this equivalent to hibernate.cfg where we define entity and relation > among tables? > > So, if I want to add new table, would it be automatically appear here in > this list? Or would there be some special steps to create new table in > Ofbiz? > > Thanks in advance > > -----Original Message----- > From: Pranay Pandey [mailto:[hidden email]] > Sent: Monday, May 12, 2014 11:29 AM > To: [hidden email] > Subject: Re: Table Mapping > > > I think you are looking for this info: > > https://localhost:8443/webtools/control/entitymaint > > https://localhost:8443/webtools/control/FindGeneric?entityName=ProductAssoc& > find=true&VIEW_SIZE=50&VIEW_INDEX=0 > > https://localhost:8443/webtools/control/ViewRelations?entityName=ProductAsso > c > > If not please elaborate your question. > > Best regards, > > Pranay Pandey > http://www.hotwaxmedia.com > > On 09-May-2014, at 2:49 PM, Eric Halim wrote: > > > Where is the table mapping? > > > > > > > > <#if productAssoc.productId == product.productId> > > > > <#assign assocProductId = productAssoc.productIdTo /> > > > > <#else> > > > > <#assign assocProductId = productAssoc.productId /> > > > > </#if> > > > > > > > > Where to check that productAssoc table is PRODUCT_ASSOC with column > > PRODUCT_ID? > > > > > > > > > > > > Thanks in advance > > > > > > > > --- > > This email is free from viruses and malware because avast! Antivirus > protection is active. > > http://www.avast.com > > > > --- > This email is free from viruses and malware because avast! Antivirus > protection is active. > http://www.avast.com > > |
|
|
In reply to this post by eric
Hi Eric, Yes you can add new tables in appropriate entitymodel.xml file. Refer how to do that from tutorial here. There are 3 sections dedicated to this thing namely: Creating Custom Entity, Extending an Existing OOTB Entity and Preparing Data For Custom Application. Best regards, Pranay http://www.hotwaxmedia.com On 12-May-2014, at 12:47 PM, Eric Halim wrote: > Yes, thanks I guess this is it. > Is this equivalent to hibernate.cfg where we define entity and relation > among tables? > > So, if I want to add new table, would it be automatically appear here in > this list? Or would there be some special steps to create new table in > Ofbiz? > > Thanks in advance > > -----Original Message----- > From: Pranay Pandey [mailto:[hidden email]] > Sent: Monday, May 12, 2014 11:29 AM > To: [hidden email] > Subject: Re: Table Mapping > > > I think you are looking for this info: > > https://localhost:8443/webtools/control/entitymaint > https://localhost:8443/webtools/control/FindGeneric?entityName=ProductAssoc& > find=true&VIEW_SIZE=50&VIEW_INDEX=0 > https://localhost:8443/webtools/control/ViewRelations?entityName=ProductAsso > c > > If not please elaborate your question. > > Best regards, > > Pranay Pandey > http://www.hotwaxmedia.com > > On 09-May-2014, at 2:49 PM, Eric Halim wrote: > >> Where is the table mapping? >> >> >> >> <#if productAssoc.productId == product.productId> >> >> <#assign assocProductId = productAssoc.productIdTo /> >> >> <#else> >> >> <#assign assocProductId = productAssoc.productId /> >> >> </#if> >> >> >> >> Where to check that productAssoc table is PRODUCT_ASSOC with column >> PRODUCT_ID? >> >> >> >> >> >> Thanks in advance >> >> >> >> --- >> This email is free from viruses and malware because avast! Antivirus > protection is active. >> http://www.avast.com > > > > --- > This email is free from viruses and malware because avast! Antivirus protection is active. > http://www.avast.com > |
|
|
Thanks. I just wondering can we just add new table/new column directly using
TOAD. What are the impacts doing so in this way? In this case, I have set Ofbiz data to Oracle DB. -----Original Message----- From: Pranay Pandey [mailto:[hidden email]] Sent: Monday, May 12, 2014 4:05 PM To: [hidden email] Subject: Re: Table Mapping Hi Eric, Yes you can add new tables in appropriate entitymodel.xml file. Refer how to do that from tutorial here. There are 3 sections dedicated to this thing namely: Creating Custom Entity, Extending an Existing OOTB Entity and Preparing Data For Custom Application. Best regards, Pranay http://www.hotwaxmedia.com On 12-May-2014, at 12:47 PM, Eric Halim wrote: > Yes, thanks I guess this is it. > Is this equivalent to hibernate.cfg where we define entity and > relation among tables? > > So, if I want to add new table, would it be automatically appear here > in this list? Or would there be some special steps to create new table > in Ofbiz? > > Thanks in advance > > -----Original Message----- > From: Pranay Pandey [mailto:[hidden email]] > Sent: Monday, May 12, 2014 11:29 AM > To: [hidden email] > Subject: Re: Table Mapping > > > I think you are looking for this info: > > https://localhost:8443/webtools/control/entitymaint > https://localhost:8443/webtools/control/FindGeneric?entityName=Product > Assoc& > find=true&VIEW_SIZE=50&VIEW_INDEX=0 > https://localhost:8443/webtools/control/ViewRelations?entityName=Produ > ctAsso > c > > If not please elaborate your question. > > Best regards, > > Pranay Pandey > http://www.hotwaxmedia.com > > On 09-May-2014, at 2:49 PM, Eric Halim wrote: > >> Where is the table mapping? >> >> >> >> <#if productAssoc.productId == product.productId> >> >> <#assign assocProductId = productAssoc.productIdTo /> >> >> <#else> >> >> <#assign assocProductId = productAssoc.productId /> >> >> </#if> >> >> >> >> Where to check that productAssoc table is PRODUCT_ASSOC with column >> PRODUCT_ID? >> >> >> >> >> >> Thanks in advance >> >> >> >> --- >> This email is free from viruses and malware because avast! Antivirus > protection is active. >> http://www.avast.com > > > > --- > This email is free from viruses and malware because avast! Antivirus > http://www.avast.com > --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
|
|
That will be helpful to make sure you know whats there in the database from OFBiz Code stand point and practices. Best regards, Pranay http://www.hotwaxmedia.com On 13-May-2014, at 8:17 AM, Eric Halim wrote: > Thanks. I just wondering can we just add new table/new column directly using > TOAD. > What are the impacts doing so in this way? > In this case, I have set Ofbiz data to Oracle DB. > > -----Original Message----- > From: Pranay Pandey [mailto:[hidden email]] > Sent: Monday, May 12, 2014 4:05 PM > To: [hidden email] > Subject: Re: Table Mapping > > > Hi Eric, > > Yes you can add new tables in appropriate entitymodel.xml file. Refer how to > do that from tutorial here. > There are 3 sections dedicated to this thing namely: Creating Custom Entity, > Extending an Existing OOTB Entity and Preparing Data For Custom Application. > > Best regards, > > Pranay > http://www.hotwaxmedia.com > > On 12-May-2014, at 12:47 PM, Eric Halim wrote: > >> Yes, thanks I guess this is it. >> Is this equivalent to hibernate.cfg where we define entity and >> relation among tables? >> >> So, if I want to add new table, would it be automatically appear here >> in this list? Or would there be some special steps to create new table >> in Ofbiz? >> >> Thanks in advance >> >> -----Original Message----- >> From: Pranay Pandey [mailto:[hidden email]] >> Sent: Monday, May 12, 2014 11:29 AM >> To: [hidden email] >> Subject: Re: Table Mapping >> >> >> I think you are looking for this info: >> >> https://localhost:8443/webtools/control/entitymaint >> https://localhost:8443/webtools/control/FindGeneric?entityName=Product >> Assoc& >> find=true&VIEW_SIZE=50&VIEW_INDEX=0 >> https://localhost:8443/webtools/control/ViewRelations?entityName=Produ >> ctAsso >> c >> >> If not please elaborate your question. >> >> Best regards, >> >> Pranay Pandey >> http://www.hotwaxmedia.com >> >> On 09-May-2014, at 2:49 PM, Eric Halim wrote: >> >>> Where is the table mapping? >>> >>> >>> >>> <#if productAssoc.productId == product.productId> >>> >>> <#assign assocProductId = productAssoc.productIdTo /> >>> >>> <#else> >>> >>> <#assign assocProductId = productAssoc.productId /> >>> >>> </#if> >>> >>> >>> >>> Where to check that productAssoc table is PRODUCT_ASSOC with column >>> PRODUCT_ID? >>> >>> >>> >>> >>> >>> Thanks in advance >>> >>> >>> >>> --- >>> This email is free from viruses and malware because avast! Antivirus >> protection is active. >>> http://www.avast.com >> >> >> >> --- >> This email is free from viruses and malware because avast! Antivirus > protection is active. >> http://www.avast.com >> > > > > --- > This email is free from viruses and malware because avast! Antivirus protection is active. > http://www.avast.com > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |