Well, in a single record in my “Task” collection, I have “Subscribers”, which are the accumulated users who subscribe to the task (in my case). I can count those. Then I have “Number of subscribers required”, which is a type “Number”, which states how many Subscribers are required in order to carry out the task. My filter should allow the task to be displayed in the list as long as the required number of subscribers has not yet been reached. When the number of subscribers has been reached, the task should no longer display in the list.
The Problem is, that I can select EITHER the “Current Task Subscribers count” OR the “Number of Subscribers required” column in the first part of the filter. Then comes the comparator. BUT I CANT SELECT EITHER after the comparator. I cannot do “Number of Subscribers is not equal to the number of subscribers required”.
In a nutshell, there doesn‘t seem to be any information about the CURRENT TASK available in the second part of the filter. So I can‘t compare one column of the current task with a different column of the current task. That is the problem.
Does that describe the problem adequately?