Filter('[dbo].[TEST_DATA]', TEST_TYPE = varTestType && TASK_ID = Value(DataCardValue52.Text) && ISACTIVE = "1")
I am having a Gallery, where I am filtering Gallery based on above formula.
When I Click PTI Button in top right corner, Then: Test_Type='PTI' , TASK_ID = Getting Value from DisplayForm and ISACTIVE = "1" (Datatype = BIT in SQL).
When I Click PTI Button in top right corner, Then: Test_Type='PDI' , TASK_ID = Getting Value from DisplayForm and ISACTIVE = "1" (Datatype = BIT in SQL)
Now, my Issue is I am getting Warning Error, and filtering is not happening, when I added ISACTIVE = "1" in Filter() and for PTI Gallery Items ISACTIVE = "1", for PDI Gallery Items ISACTIVE = "0".
According to my formula, when I click PTI it must show Items where ISACTIVE = "1". But, it is showing blank.
Solved! Go to Solution.
Hi @Chandu ,
BIT values in SQL have 3 possible values: true, false, null. Please use true, false to Filter the gallery instead.
Regards,
Mona
Hi @Chandu ,
BIT values in SQL have 3 possible values: true, false, null. Please use true, false to Filter the gallery instead.
Regards,
Mona
User | Count |
---|---|
227 | |
101 | |
93 | |
56 | |
30 |
User | Count |
---|---|
288 | |
116 | |
109 | |
62 | |
58 |