Skip to content
+1-888-319-3663

COMMUNITY FORUM

Multiple rows in EXT01101 with the same Field_ID

Kevin Reed asked 5 years ago
I have a custom SSRS report that uses ext01101.strga255 to display extended company name. My SQL query joins on the ext01101 table where ext01101.field_id = 104. The issue is that there are multiple rows in this table with the same Field_ID. I’m assuming these are for different revisions, so how can I determine which record is correct / latest? Should I take the one with highest Extender_Record_ID? Or highest DEX_ROW_ID? Is there another table I can join in to determine which Extender_Record_ID is correct?
 
 




Extender_Record_ID


Field_ID


STRGA255


DEX_ROW_ID




2


104


Company Name


2




3


104


The Company Name


3




4


104


Name, The Company


4




 
Answers
Mark Anderson Staff answered 5 years ago
based on your data, a user has entered 4 separate records,which is why you have 4 record ID’s in your system. ¬†Based on the highest Extender_Record_ID that would be the latest record added. As this is your data it would be hard to say which record you want. Which of the values are you showing the correct Company Name? If it is the one with Extender_Record_ID = 4 then select the max record ID.

If you would like to submit an answer or comment, please sign in to the eOne portal.