[development] tying user and content_profile together in a view or module
jeff at ayendesigns.com
Thu Oct 29 13:25:24 UTC 2009
Thanks Andrew and Larry, I'm part-way there now. There's a third step,
which is where it's failing.
What I'm trying to achieve is a basic (on any billing system) customer
report. So it needs the e-mail (user), profile info... and (third step)
their address, which is kept in the Ubercart order.
So, I did a node view. Filtered on Profile content type. Added (for
testing) the user email field. And all is well.
Then, time for the address info. I tried first without relationship to
add the Payer Phone from the field list (since it was offered). Got a
SQL error of the bill-to-phone column being unknown. Ok, so then I added
a relationship for Order UID, and received "ambiguous field order_uid.
So I added Order UID in the fields list, and the error went away. Oddly,
the Payer Phone did not offer a relationship when I did that, and I
still got an unknown column for bill-to-phone.
Then I tried making the relationship to the Profile instead (odd that it
offered that, since I was starting with the profile). Now, the Payer
Phone offers a relationship, but when i select it, I get an SQL error of
unknown field node_users__uc_orders.nid.
More information about the development