Solved: Exists in CDS view

christelle_scott · ‎2014 Nov 04

Hi

I wonder if the Exists condition can be used in the CDS view (WHERE EXISTS (SELECT * FROM .... ) .

I actually never managed to used subqueries in any cds view so I wonder if this is a limitation for CDS view or if I just do not get the syntax right.

Thanks for any feedback and examples!

Christelle

christian_seitel · ‎2014 Nov 10

Hi, subqueries are not yet supported. In the CDS-editor you may press F1 and browse the documentation to find out what features are supported. You will not find an EXISTS there.

sundaresan_k · ‎2014 Nov 04

Dear Christelle,

Can you explain little bit more the context where you want to check the existence?

Best regards

Sundar

christian_seitel · ‎2014 Nov 10

Hi, subqueries are not yet supported. In the CDS-editor you may press F1 and browse the documentation to find out what features are supported. You will not find an EXISTS there.

christelle_scott · ‎2014 Nov 13

Thank you for your answer!