News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... how to add calculated ...

Finance | Project Operations, Human Resources, ...

Suggested answer

how to add calculated field in view using view method

(0) Share

Report

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 Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Martin Dráb 231,305 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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,305 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans