Hi
I have a problem getting a portal to filter properly.
I have, for purpose of this discussion, 3 tables
Account <- Order -> Product
Accounts have Orders
Orders are for Products
Products have Product Types
Product has globals for each Type
for example "TYPE_SUBSCRIPTION = 'Newsletter'"
Accounts have Account IDs and calculation fields that represent each Product Type.
For example there is a field "Account::TYPE_SUBSCRIPTION" set to "Product::TYPE_SUBSCRIPTION"
This is done via a "1" = "1" relationship to Product
Orders have account IDs and Product IDs
Products have Product IDs and Product Types
I wish to add a portal to Account that shows all Orders for that account for a given Product Type.
I set the portal to view records from the relationship "Subscriptions"
1) I defined relationship Subscriptions as "Account:account_id = Order:account_id" and it shows the orders and the correct product types in the portal
2) If I then add "Account::TYPE_SUBSCRIPTION = Order::Product_Type" nothing is shown in the portal.
3) If I reduce the relationship to just the Type field constraint ("Account::TYPE_SUBSCRIPTION = Order::Product_Type") without the account_id, still nothing is shown.
So close... but I cannot figure out what is wrong.
All help greatly appreciated.
If rather than debug this, someone has an example or explanation on how to have a view that shows the Orders of a given type when the order's type is itself a reference to a related table on Order that would be just as welcome.
Thanks