Filter ODATA for two Sharepoint lists

[Yuras2022]

Hello!

I use two Sharepoint lists for storing app data:

and

The RequestID from the second table is equal to the ID from the first table.

It needs to change ApprovalStatus when Status2 was updated. But one Request can have some Challenges. 

To get necessary Challenges, I have leveraged the next ODATA filter:

As result, I get all Challenges with ApprovalStatus that equal "New". The first part of filter does not work.

What should I do in given situation? Could you write me the correct ODATA request?

Thank you in advance.

[RobElliott]

You've got an incorrect single ) in the first part of the filter.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[Yuras2022]

Hello, Rob.

What is incorrect single?

Here, RequestID is the value from the second table and ID is the value from the first table.

Could you tell me correct ODATA request?

[RobElliott]

It's the closing bracket/parenthesis on the far right of your image in your previous post. There isn't an equivalent opening bracket so it will give an error.

[Yuras2022]

Thank you.

However, it is another problem here. Which? I do not know...