NOTE field does not display in the SFX Menu

• Article Type: General
• Product: SFX
• Product Version: 3

Description:
Even though I have entered a note in the NOTE field of the target/service/portfolio, the note does not display in the SFX Menu.

Resolution:
The reason why the notes are not appearing is due to the fact that some of the empty object portfolio fields did not have a NULL value in version 2, so when they migrated to version 3, the program “thinks” that the fields are not null and therefore does not allow the higher-level (target service) note fields to be displayed. The templates are actually functioning correctly.

The issue is that the logic for page display utilizes a hierarchy for displaying notes from the various items in the database (target, target-service, object). When a non-null entry is present in a lower-level object, such as the object record, a note from a higher-level object (such as target-service) will be obscured. Some of the object entries had a value of an empty string ( "" ) which are identified as being non-null.

I am attaching a txt document with the exact commands that you need to execute in mysql to fix the problem. The example can be used for both NOTE and AUTHENTICATION fields.