Hi, I have a view ProjPostedHourCostTransactions, inside the view I have a datasource view ProjPostTransView, both the views are having field as ResourceCategory.
Inside ProjPostedHourCostTransactions I am returning RoleId by using the below code, but I am unable to get the RoleId value.
how to add calculated field in view using view method
The purpose of a computed column method is generating a piece of T-SQL code that is injected to a view defining in database. Your code is returning the value of RoleId field, which definitely doesn't contain SQL code you want.
First of all, consider if you can simply use a joined data source. It would be much simpler than writing a computed column.
If a computed column is necessary, first write SQL code you want to generate (e.g. SELECT RoleId from PSASchedRole WHERE ...). When you know what SQL you want to generate, write X++ for it (without hard-coded table names etc.).
When you've done it and you aren't getting correct data, look at the view definition in database and compare the actual SQL code with the one you wanted to generate.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.