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
Page 1 / 1
@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 !