Skip to main content

Hi, In the Result Grid Tab, when i add a column and I set it to the attribute, it show the Attribute description by default. 

How to show the Attibute Value ID instead of the Description?

I already tried a lot of workaround like Attibute.Value without any succes.

I don’t want to use “schema field” because i will need to put this in formula .

My starting point is from the Non stock list PX.Objects.IN.InventoryItem

Thanks

 

 

@raphrf The attribute should already be part of the item, the field would look like:

>InventoryItem.FILGAUGE_Attributes]

The attributes themselves are stored in the CSAnswers table and joining to InventoryItem table on NoteID = RefNoteID you can display the value off CSAnswers if needed, though it should appear as expected in the InventoryItem table, like this:

Otherwise I guess I may need to see your result to better understand the issue


Hi , first thanks for the quick answer. I’m not sure to understand the answer

I tried to add the CSanswer table with an inner join as explained.

But i have lot more row than the beginning, it repeat each row for each attributes.

 

I have more then one attribute related with the row, but i want to do this with only one attribute

 

I put more image to help :

We want this :

 

The attribute is the last one here

 

It map the description and not the attribute value in the GI: 

 


Hi @raphrf were you able to find a solution? Thank you!


Hi Chris,thanks for the reminder !

Yes I am able now!

I added the table CSANSWER:

Relation added for CSANSWER:

 

Added the rows into Result Grid(i splitted it for my own needs)

 

Result as wanted :) :

Thanks for all 

Really appreciated!!!  😁

This community is awesome


Thank you for sharing your solution with the community @raphrf !


Reply