Retrieve value of whole column and add them and show as sum

(0) Share

Report

Posted on by Raj12144

I need to add the sum the quantity of each item added in the order product table and show the total sum into another column..
if 10 products are in the order I have to add the quantity of all 10 into total and then set this total into some field need to do it with the help of Plugin only

All responses (3)

Answers (0)

Suggested answer

Bipin D365 28,964 Super User 2024 Season 1 on at

Like (0)

Report

RE: Retrieve value of whole column and add them and show as sum

Hi,

You can convert fetchXml to query expression using fetchXml builder tool in xrmtoolbox

www.xrmtoolbox.com/.../
Raj12144 35 on at

Like (0)

Report

RE: Retrieve value of whole column and add them and show as sum

I don't want to use Fetch XML.

I need to use Query Expression...
Suggested answer

Bipin D365 28,964 Super User 2024 Season 1 on at

Like (0)

Report

RE: Retrieve value of whole column and add them and show as sum

Hi,

Use fetchXml to retrieve records

carldesouza.com/.../

Then use service.Update to update that field

Entity entity= new Entity("your entity name");

entity.Id= guid:

entity["your field name]= value;

service.Update(entity);