Can we Use Where condition/clause inside an Expression for a particular Column of a Table, If Yes Please Let me know with example?

Question

Hello Team,

I have write a query inside an Expression (select e.email_id from email e where e.email_id=@email_id) for column (email_id ) to fetch email_id dynamically.

Can anyone suggest me if the above code is correct for write where condition inside a column Expression?

Need help !

Regards,

Sujit

Erwin Ekkel · Accepted Answer

I'm not sure what you are trying to accomplish, can you explain what you want to show on the screen? You already have the email_id so I don't see the added value of the expression column. To answer your question you have to use t1.email_id instead of the variable. You can read more on this and see an example

here: https://docs.thinkwisesoftware.com/docs/sf/data_model#expression-dependencies

Renée Evertzen · Answer

My apologies, I accidentally marked Erwin's answer as the best answer, thus solving the topic 😓. @sujit : Feel free to ignore this and continue the discussion if Erwin's answer is not sufficient to solve your question !

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded