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.
Additional Information
note,field,menu,SFX,mysql,display
- Article last edited: 10/8/2013