View Computed Column to display value

(0) Share

Report

Posted on by D365_FO_Technical_Te

124

Hello everyone,

I have one requirement, i am creating one view. And I want to show some values in view's computed column with the help of methods which I have to create on view.

I have to use multiple join conditions on view methods. But on view methods have to be static methods. So I am not able to use "this" keyword.

Eg: on view i have itemId field, now with the use of that item Id field I have to display some other values from other table.

So how can I get that current value in my methods,as we cannot use this keyword.

I have the same question (0)

All responses (3)

Answers (0)

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

The purpose of a computed column method is generating a piece of T-SQL to be injected to the view definition of database synchronization. Refering to a particular record of the view makes no sense there. So you seem to be trying a wrong thing.

If you explain your business requirement to us, we'll likely be able to suggest a technical solution that can actually work.

Was this reply helpful? Yes No
D365_FO_Technical_Te 124 on at

Like (0)

Report

I am using view. In view i have multiple fields coming from different DS. But I want to show some more fields on view which are not present in current Datasources of view. So for that I want to use display method on view to show records on those unbounded columns also. So I was trying to use computed columns and trying to use viewmethod property on that. But the problem is I want to show that computed column with respect to current record's field.

Was this reply helpful? Yes No
Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

What you're describing is not the problem that business users want to address. You're describing your technical design - and we already know that is wrong and can't be used. Display methods are used to directly obtain values, not to generate T-SQL code, therefore trying to use them in computed columns is impossible.

Either use display methods and forget computed columns, or use computed columns, but then you can't use your display methods there. You would have to rewrite them to T-SQL, if it's possible at all.

What you need to do is throwing away your design and look at the actual business requirements. Only when you know what users need, you can start designing a technical solution.

For example, if users want to see the view (and the calculated values) in a form, consider if filtering and sorting by them is needed. If not, you can simply use display methods (after taking perfomance into account). If not, using computed columns may be a solution, if the logic can be written in T-SQL (e.g. it doesn't depend on X++ classes). But that's not the only way. For example, you could use a temporary table and put results of display methods to this table.

Was this reply helpful? Yes No

Join the conversation

Community site session details

View Computed Column to display value

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

View Computed Column to display value

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates