web

You’re offline. This is a read only version of the page.

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!!

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Martin Dráb 240,075 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 393 Super User 2026 Season 1

#2

#3

Martin Dráb 252 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans