addQuery in Relationship

[Miguel1]

Hi experts, I made a relationship using addQuery as below

(function refineQuery(current, parent) {

// Add your code here, such as current.addQuery(field, value);
current.addQuery("time_card", current.task.number);
current.addQuery('state', 'IN', 'approved,processed');

})(current, parent);

this query show only approved and processed time cards but shows all the time cards from all the projects, so, I would like that show only the time cards from a project with the same EG Project ID.
I would like to know how can I do this?

Does anyone have any ideas?
thanks so much!!

[Pranav Bhagat]

You can add a query for same project

current.addQuery(‘projectid', ‘number');

[Miguel1]

Hi Pranav! thanks for answering!

Doesn't work the ID is in both tables but I still can't relate them  

Any other suggestions?

[Mike Patel]

Change current.addQuery("time_card", current.task.number); To current.addQuery("time_card", current.task.sys_id);

[Miguel1]

Hi Mike! Thanks for answering!

Doesn't work... 
by the way the ID are in both tables I need to related with the query but i can't relate them