0

Getting wrong values when trying to filter specific custom_fields values with the Asana API

Dear community,

for the last week I'm trying to filter tasks that are in a specific project in Asana. The tasks have 4 custom fields options: Question, To do, In Progress, Verify and Done. I have made a table where I only want to show the tasks with the custom field "Question". I have checked the JSON file and the data I get back is correct. The tasks each have their correct custom fields value assigned. However when I SELECT the "Question" tasks I get tasks from random custom fields. 

I have found one task in the data list called "In het footermenu en dan de 3e kolom staat in het engels "Desktop view". In de andere talen niet. Waarvoor is dit?". This task has the correct "Question" custom fields value. However when I SELECT the data, it appears under the column that only selects the tasks that are marked with the custom fields value "Done".

I think that it has to do something with the way I SELECT the values. This is my SELECT formula: SELECT(@/data/name;, AND(@/data/custom_fields[4]/enum_value/name;="Question",@/data/completed;="false"))

The custom_fields[4] is the custom fields that have the question, to do, in progress, verify and done options. 

 

Does anyone know what I do wrong?

 

Thank you for your time and effort,

Dennis S.

1 comment

  • 0
    Avatar
    Janice Janczyn

    Hi Dennis, 

    My first suspicion is that /data/name doesn't align correctly with /data/custom_fields[4]/enum_value/name. A quick check would be to evaluate each in your formula and see whether they return the same number of items. To help you, we may need to take a look at your data, so I suggest you email support@klipfolio.com and ensure support access is enabled.

    Thank you,
                Janice

Please sign in to leave a comment.