select *, CAST(substring(title, -5) as int) as PropertyId
from {{ getAllTasks.data.value }} as allTasks
this returns data.
with result PropertyId:10002
but if I add
select *, CAST(substring(title, -5) as int) as PropertyId
from {{ getAllTasks.data.value }} as allTasks
where allTasks.PropertyId = 10002
nothing comes back...