Null values and virtual table
17 March, 2014
I have problems with null values when using a free hand sql virtual table. The lines with null fields are missing in the reports. Do you have a work around for it? (updated YF version on MS SQL DB)
Hi Rami,
Can you please give us a little more info as not able to replicate your issue.
E.g.
-Full Yellowfin verson (e.g. Yellowfin 7 Feb 25th release)
-SQL Query used
-Screenshot of report output
Thanks,
David
Can you please give us a little more info as not able to replicate your issue.
E.g.
-Full Yellowfin verson (e.g. Yellowfin 7 Feb 25th release)
-SQL Query used
-Screenshot of report output
Thanks,
David
David,
We're working with the YF7 and the latest update of Feb.25th.
DB - MS SQL 2012 SP1
The information with "NULL" values can be found only with "VIEW DATA" on the table.
The lines with null fields could not be found in the report.
Please see the screenshot and the SQL with the nulls (NULL.TXT & NULL.JPG).
When I used the "isnull" phrase, I could find the information in the report (NO_NULLS.TXT & NO_NULLS.JPG).
When I cached the view, the nulls (without using "isnull") could be found in the report, using the "Is Null" filter.
Rami
We're working with the YF7 and the latest update of Feb.25th.
DB - MS SQL 2012 SP1
The information with "NULL" values can be found only with "VIEW DATA" on the table.
The lines with null fields could not be found in the report.
Please see the screenshot and the SQL with the nulls (NULL.TXT & NULL.JPG).
When I used the "isnull" phrase, I could find the information in the report (NO_NULLS.TXT & NO_NULLS.JPG).
When I cached the view, the nulls (without using "isnull") could be found in the report, using the "Is Null" filter.
Rami
If it is marked as "Answered", it is not yet....
Hi Rami,
are you absolutely sure that the rows with are missed from the report?
Could you please attach some screenshots that would show the number of rows returned by the report without the ISNULL operator used and with the operator and actual SQL queries generated by Yellowfin.
Regards,
Artem
are you absolutely sure that the rows with are missed from the report?
Could you please attach some screenshots that would show the number of rows returned by the report without the ISNULL operator used and with the operator and actual SQL queries generated by Yellowfin.
Regards,
Artem