Association view Lookup

Support
#1

Hi,

Related to your quick start movie part 3, High productivity application development platform
There is any possibility to see Date, Amount + Customer(tab) in Orders?
I saw that in a view which includes a lookup entity, this lookup entity cannot see in a view table regardless view type (local, base, minimal or customized).
Is there a solution to view all entities (lookup type included as well?

image
In this case obvious is not necessary to display Customer because we are already on Customer view, but there are cases when we have Lookup to another (a third) entity.

#2

If I understand correctly:

I have got tables to show referenced fields, but Cuba Studio sometimes is a little bit flakey when you try to set them up. If you edit the editor XML file in a text editor or IDE, then you can just fill in setup manually.

<columns>
    <column id="date"/>
    <column id="amount"/>
    <column id="customer.name"/>
    <column id="customer.email"/>
</columns>
#4

Hi,

Honestly, I didn’t understand what you want to do. Do you want to see the table with all customers in the Order editor? Could you please rephrase the question?

#5

Hey Ray,
Hey Olga,
Thank you for your answer.
Unfortunately the problem is more complex. Even now appear the title of the box doesn’t display anything, the box is empty. I will try to be more specific.
I have an Entity Payment with a Many-to-Many relation with Transaction, and for Payment-view I have a Transaction (read only) table with collectionDatasource:transactionDs:

select e from crmrai$Transaction e
inner join e.payment p
where p.id = :ds$paymentDs

The table capture all transaction fields except lookup fields - Seller, Buyer, Reseller (that are linked One-to-One to 3rd Entity - Organisation).
image

Is a normal behavior? How can I capture lookup fields as well?

#6

You should create a view for Transaction that includes these reference fields, and use this transaction-view for the transaction field in your payment-view.

#7

Thank you a lot, Olga. It works.
I already tried this in the past but now I added manually in Idea the columns Seller, Buyer and Reseller.