Hey guys,
My script/query has been running like clockwork for the last couple of weeks without any issues. It’s a basic query with some filters, applies a sum and spits out the total number.
In the last few days (I cant exactly say when as I’ve been off from work), it’s been returning 0 value. A bit of debugging shows a date filter in line 6 to be the culprit. The whole query looks like this:
{
boards (ids: ***){
items_page (limit: 500,
query_params:
{rules: [{column_id: “group”, compare_value: [“topics”], operator:any_of}
{column_id: “date2”, compare_value: [“$$$blank$$$”], operator:any_of}
{column_id: “project_area”, compare_value: [“Farleigh”], operator: not_contains_text}
{column_id: “status0”, compare_value: [5], operator: not_any_of}
{column_id: “status_25”, compare_value: [1], operator: not_any_of}
{column_id: “status_25”, compare_value: [10], operator: not_any_of}
{column_id: “status_1”, compare_value: [15], operator: not_any_of}
{column_id: “status04”, compare_value: [3], operator: not_any_of}
]}) {
cursor
items {
id
name
}
}
}
}
If I remove the date filter, I get results. But with it there, I get a 0 value.
Again, this was working up until very recently. I’ve had a quick search but can’t see anything obvious. Any ideas?