+2I have created an IAL with the below query with a where condition
When I am using this IAL for Quick Information source and running the Business Reporter Report.
The Data rendered includes with the ZERO quantities.
I am having this issue with all IAL’s having Where Clause. system is not filtering the data on where clause for the IAL Reports.
Best answer by Dilmi Gunasiri
Hi
You need to include all the columns that are used in the Where clause in the select statement.
Further, is the IAL loaded from the file. If not kindly use the RMB option ‘Save to File’ and check if the file has generated the code correctly.
Regards,
Dilmi.
I have created an IAL with the below query with a where condition
When I am using this IAL for Quick Information source and running the Business Reporter Report.
The Data rendered includes with the ZERO quantities.
I am having this issue with all IAL’s having Where Clause. system is not filtering the data on where clause for the IAL Reports.
Put the where clause in the select statement and see if that makes a difference.
+7Hi
You need to include all the columns that are used in the Where clause in the select statement.
Further, is the IAL loaded from the file. If not kindly use the RMB option ‘Save to File’ and check if the file has generated the code correctly.
Regards,
Dilmi.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
