I created a custom Attribute for an Inventory Item. I want to print both the Value ID and the Description on the Report.
0001 Ryan Harris
When i select the attribute from the Inventory Item. It only prints the Description. How can i get both to print on my report?
Best answer by sweta68
View originalHi
I believe, you need to join InventoryItem table to CSAnswers by NoteID and then further join CSAttributeDetail table by AttributeID and Value.
Then extract value and description fields from CSAttributeDetail table.
Hope, it helps!
Regards,
Sweta
+1
Alternatively, if you don’t want to make the join you can use this formula =Concat(ATTR_user,’’)
This works because the value that is saved is the AttributeID, but for visual representattion it switches it to the descripción. If you “Trick” the system by using the Concat function it will take the AttributeID directly.
Hope this helps.
+4
Take a date field for example, if you call the date field into the GI results you may not see the time stamp on it, not to mention the date will correspond to the UI time zone selected for the user.
If on the GI, instead of selecting just the field (ex. ARInvoice | DocDate), you can use =[ARInvoice.DocDate] and this will show what is stored in SQL for that field, which will show the time stamp also.
This is important to factor in if you are using other expressions and the end result may not = what you think it does since just by using the field in an expression you are forcing the SQL value, so in that sense, for a date of 8/25/2023 you would instead see 08/25/2023 12:00:00 AM (assuming it has a null time stamp).
Otherwise
Hi
If I have an Attribute ID called EQUIPTYPE with a list of Value ID’s such as:
AIR
AIRAC
CWB
What would your formula look like?
Thanks!
+1
=Concat(ATTR_user,’’)
The “ATTR_user” is the name of the field as it appears in the selection tree.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
