how to add calculated field in view using view method

(0) Share

Report

Posted on by D365 ER

167

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.

Please Suggest.

public static server str RoleId()

{

str resourceCategory = SysComputedColumn::returnField(tableStr(ProjPostedHourCostTransactions), identifierStr(ProjPostTransView), fieldStr(ProjPostTransView, ResourceCategory));
ResourceCategoryRecId resourceCategoryId = str2Int64(resourceCategory);
return PSASchedRole::find(resourceCategoryId).RoleId;

}

Thanks!!

All responses (1)

Answers (0)

Suggested answer

Martin Dráb 230,370 Most Valuable Professional on at

Like (1)

Report

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.