How to connect asset to history line table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2025 03:12 AM
Ho can i connect the al_hardware table to the "sys_history_line" table to report the field value changes showing old value and new value.
I have created an database view but i am getting only hardware table field not from the history line table
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2025 04:00 AM
Hi @singhr14,
navigate to the sys_dictionary, locate the alm_hardware table, collection: type, and check the value in audit, it must be true, otherwise you will not get the new / old values in the sys_audit table.
Please refer to that and let me know in case of issue or how it goes
———
/* If my response wasn’t a total disaster ↙️ ⭐ drop a Kudos or Accept as Solution ✅ ↘️ Cheers! */
/* If my response wasn’t a total disaster ↙️ ⭐ drop a Kudos or Accept as Solution ✅ ↘️ Cheers! */