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
Best answer by Erwin Ekkel
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
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
+4My apologies, I accidentally marked Erwin's answer as the best answer, thus solving the topic 😓.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
