0 votes

Hello,

I need to customize the relation Oppo Prod for a client.
I added several custom fields in Product Entity and Oppo_Prod Entity and now I want to display them on the relation's edit grid.
But I can't find what query is executed to get the fields mapped in the GetRelationGrid Macro :

/* Custom de la relation Prod-Oppo */
TabContentProds.Oppo {[
<div class="content tabs-content-item" id="tab-prod">
<div class="row">
<div class="small-12 medium-1 columns">
<button type="button" class="icon i-add <%IfReadOnly(detail='Prod', then='disabled')%>" title="<%GetLabel('Add Link to Product')%>" data-msg="addProduct"></button>
<%AddRelationButton(entity='Prod')%>
</div>
<div class="small-12 medium-11 columns">
<h3 class="section-title"><%GetLabel("Linked products")%></h3>
</div>
</div>
<%OnMultiCurrency(0=, else=|<div id="currcyError"><span class="error"><%GetLabel("Warning: The currency must be set before adding products")%></span></div>|)%>
<%Delay(1)%>GetRelationGrid(columndefs="GridEditColumns.txt", entity="Prod",
columns="FULLNAME,QUANTITY,PRICE,DISCOUNT,COMMENT,VAT,TOTAL,CONSO_RATE{HIDDEN},CONSO_TOTAL{HIDDEN},<%IfReadOnly(else=|SORTDELETE|)%>,PRICE1")%>
</div>

When I try to add a column here, I get an error message because the column doesn't exist in the DS of Oppo_Prod :

Message: DSOppoEdit6ProdOppo: Field 'PRICE1' not found

If someone can help me on this, just to find which query I have to modified, thank you all.

closed with the note: I found a solution by myself
asked in Efficy/ Client side by (112 points)
closed by
You should share your solution here. Imho the solution is about finding the good sys_query or sys_tableviews and customize it.
Cache issue by the way.
You have to customize the tableview Prod_Oppo.
1,166 questions
1,424 answers
1,715 comments
325 users