WAS CHANGED not working with document Attributes

rocketman

3015	MySql	Windows server 2019
{Put Build No Here}	{Put DB Here}	{Put OS Here}

Trying to detect when someone has uploaded a new document or replacing an out of date document. The documents are stored in the file system not the database.
Neither WAS CHANGED nor OLD_Value <> to New Value work. Anyone found a solution for this. Monty mentioned a trigger?

Jaymer

Over the years, I check to see if the filename or filesize has changed. Usually this is sufficient.

rocketman

Jaymer

Thanks for the heads up. I used a combination of stuff to get it working. Had to create a non persistent BO to to hold filenames before the edit and then compare after the edit was complete. Haven’t got it to work in a “rule” because “OLD_VALUE” doesn’t work, but for the benefit of anyone following, here’s the process.

FIND Members WHERE Members=LoggedInMembers
CREATE NPBO_Picker WITH NPBO_Picker.P1=FILE_NAME(Members.LicenseDoc),NPBO_Picker.P2=FILE_NAME(Members.MedicalDoc)
EDIT Members USING DocUpload
If Members.LicenseDoc IS DEFINED AND FILE_NAME(Members.LicenseDoc) <>NPBO_Picker.P1 THEN
CREATE Alerts WITH Alerts.AlertTo=Members,Alerts.AlertFrom=LoggedInMembers,Alerts.Message=LoggedInMembers.FirstName+‘ ’+LoggedInMembers.Surname+‘ has uploaded their License Details to their record. You might want to check it out’,Alerts.AllAdmins=‘Yes’
ELSE IF Members.LicenseDoc IS UNDEFINED AND FILE_NAME(Members.LicenseDoc) <>NPBO_Picker.P1 THEN
CREATE Alerts WITH Alerts.AlertTo=Members,Alerts.AlertFrom=LoggedInMembers,Alerts.Message=LoggedInMembers.FirstName+‘ ’+LoggedInMembers.Surname+‘ has removed their License Details from their record. You might want to check it out’,Alerts.AllAdmins=‘Yes’