Defects
SBM: Report always returns "Sorry, no data was found meeting conditions of this report." when filter for trinary field
 |
Your subscription to document D27984 will expire in 326 days (Renew). To cancel this subscription, click Cancel Subscription above. |
| ID: | D27984 | |
| Published: | 01 June 2023 | |
| Updated: | 07 November 2023 |
Defect Id
DEF348339
Originally Reported Against
SBM 12.1
Also Affects
SBM 12.1 Hotfix
SBM 12.1 Hotfix
SBM 12.1 Hotfix
SBM SBM 12.1 Hotfix
SBM 12.1 Hotfix
SBM 12.1 Hotfix
SBM SBM 12.1 Hotfix
Description
Problem with listing report where search filter is trinary (rather than binary) field and parameter is "Query at Runtime“.
Result of that report is wrong when run report and choose nothing for that parameter.
Result should be: all items
But result is: "Sorry, no data was found meeting conditions of this report."
The same report works OK for Binary field.
Resolution
Workaround:
You can optionally use a workaround including advance SQL Conditions. Use the database field name of the trinary field.
Note: Value = 0 will be the first option Yes, 1 will be the No and Unknow will be 2.
In the report add the query like this:
@where TS_BINTRIN = 1 OR TS_BINTRIN =2 OR TS_BINTRIN =0
