Wrong result in count statement,

HBT
Silver 4
Silver 4

In Bot-Events-Process- branch on a condition- Expression Assistant- Condition

Although there are records in the table, the query below returned the value of the number of records a week ago, but now returns 0.

COUNT(SELECT(table[XID],[XID]=[_THISROW].[ID]))=0 ( Yes or No )

For example, the return result should be 1=0, but it is 0=0.

I solved my problem using other logic, but this problem needs to be investigated and solved.

I think it's a new bug. Please research and analyze this topic.

0 1 150
1 REPLY 1
Top Labels in this Space