Syntax to fetch pending transfer details from Data_cache column in hrc_txn_data
Summary
Syntax to fetch pending transfer details from Data_cache column in hrc_txn_dataContent
Hi,
We need to fetch the pending transaction Transfer details like New Location,New Position,New Grade,New Job etc. We are aware that We can capture these details in data_cache column in hrc_txn_data table. As these column captures many entries, how can we fetch only one value(say New location, New Position,New Grade,New job etc.)? Is there any syntax to fetch that alone? Please suggest.
Thanks,
Nirmal kumar
Tagged:
1