Cannot get specific element entry values from XML data cache column for pending transaction

Summary:

We are not able to get the accurate element entry value from XML data cache element entry rows data , we are only fetching values if they have in element entries table but not for pending transaction? Any idea how to get that

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

We have below code , Valuesc column stores hours worked , Amount , Hours etc , but currently we are getting values for those element entries which are in element entries value tables for approved transaction , but when transaction is pending it doesnt have value but we need that , please share some idea on this , because in xml data we dont have input value names thats why we are linking with element entries tables i hope you got that