I have a problem with NULLDISPLAY function during app ODAG generation. Null values don't get converted to 'Not Available'. Please refer to the following snippet:
Set NULLDISPLAY = 'Not Available';
NoConcatenate DETTAGLIO: LOAD *, $(v_complementary_fields); SQL SELECT $(v_Load) FROM TABLE $(WHERE_PART) and ($(WHERE_PART_TIPOLOGIA_ANALISI)) ;
Where:
$(v_Load) are the selected fields
$(v_complementary_fields) are the same fields extracted by $(v_Load) renamed
$(WHERE_PART) and $(WHERE_PART_TIPOLOGIA_ANALISI)are parametric where conditions submitted to the DB.
Please note that a similar script runs without using ODAG and Null values are correctly converted to the default value.
Can you tell me if NULLDISPLAY (or NullAsValue) and ODAG are incompatible?
I tried to look online but I couldn't find any document regarding Odag and NULLDISPLAY (Or NullAsValue) compatibility.
