Requirement: I need an LWC on Case record lightning page which should listen to another table called customobj1__c and display just the most recent record in that table. When the most recent record in customobj1__c table is updated by navigating to the detail page of that record I want the LWC which is on the Case record page to auto re-render and show the updated data.
Question: I tried using wire service to get this to work. I tried wire to property, wire to a function using a custom apex method but it didn't work for some reason. I read in documentation that wire service provides immutable data so I don't know if this is the way to go. I also tried getRecord of uiRecordApi and wired it to a property and a function both of them didn't work. How can we achieve this requirement?