StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POJoin tables and display the data in Magento Grid using XML
primarykey
Id
15185398
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-03-03T11:58:18.043
FavoriteCount
0
LastActivityDate
2013-09-25T10:24:53.270
LastEditDate
LastEditorUserId
0
OwnerUserId
1704524
ParentId
0
PostTypeId
1
Score
0
ViewCount
406
LastEditorDisplayName
text
Body
<p>I am trying to customise Magento Sales/Order/Grid by adding columns to display data for </p> <p>Customer_Id Billing_Address Shipping_Address</p> <p>I've created a module following an earlier post </p> <p>I am now trying to join the tables but haven't been able to figure out how to do this using XML. </p> <pre><code><gridcontrol> <grids> <sales_order_grid>  <shipping_address> <add> <header>Shipping Address</header>  <join table="sales_flat_order_address" condition="sales_flat_order_address.entity_id={{table}}.street" field="street"/> </add> <after>status</after> </shipping_address> <billing_address> <add> <header>Billing Address</header>  <join table="sales_flat_order_address" condition="sales_flat_order_address.entity_id={{table}}.street" field="street"/> </add> <after>status</after> </billing_address> <customer_id> <add> <header>Customer Id</header>  <join table="sales_flat_order" condition="main_table.cutomer_id={{table}}.customer_id" field="customer_id"/> </add> <after>status</after> </customer_id> </sales_order_grid> </grids> </gridcontrol> </code></pre> <p>I have the new columns showing in my grid but there are empty so I know I am doing something incorrectly and I assume it is something really simple. I would be grateful if someone could show me how to join the correct tables using this method.</p>
Tags
<magento>
Title
Join tables and display the data in Magento Grid using XML
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USuser1704524
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COI know you are trying to get a hard job done. Why don't you use an extension. please check out http://www.magentocommerce.com/magento-connect/enhanced-admin-grids-editor.html
  singulars
  PostPostId
  POJoin tables and display the data in Magento Grid using XML
  UserUserId
  USSAM
2. CO@SAM I had used this extension but it doesn't allow me to add columns to the Sales/Order_Grid. Everywhere else is fine including the Manage products grid but the extension is still in Alpha so some functionality has yet to be added.
  singulars
  PostPostId
  POJoin tables and display the data in Magento Grid using XML
  UserUserId
  USuser1704524

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.