I want to extend the method and add the condition of Query

(0) Share

Report

Posted on by Nobuaki Baba

The PurchReceiptsListDP.printInventTrans () method has the following SQL description.

while select inventTrans
        order by StatusReceipt, InventDimId
where inventTrans.StatusReceipt     == StatusReceipt::Ordered
    && inventTrans.StatusIssue   == StatusIssue::None
join localInventDim
    where localInventDim.InventDimId == inventTrans.InventDimId
exists join localInventTransOrigin
    where localInventTransOrigin.InventTransId  == ventReceiptsListTrans.InventTransId
    &&  inventTrans.InventTransOrigin       == localInventTransOrigin.RecId

inventTrans.StatusReceipt == StatusReceipt::Ordered

(inventTrans.StatusReceipt == StatusReceipt::Ordered ||
inventTrans.StatusReceipt == StatusReceipt::Registered)

How can this be realized with the Extension of Method?

Categories:

Development / Customization / SDK

All responses (4)

Answers (0)

Sort by

Suggested answer

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

Like (1)

Report
Copy link

Link copied!

Extensions don't allow modifications of existing code. You'll have to find another technical design to achieve your business requirement.
Suggested answer

Sukrut Parab 71,741 Moderator on at

Like (1)

Report
Copy link

Link copied!

If you see code this method is called from setPurchReceiptsListDetailsTmp method which is called from createData method and it is public, you can use COC on the createdata method , call standard method first and then write your custom code to update records in temp table according to your need
Nobuaki Baba on at

Like (0)

Report
Copy link

Link copied!

Thank you, Parab.I will try it.
Mariano Gracia on at

Like (0)

Report
Copy link

Link copied!

With PU22 you can use SysDa API:

https://blogs.msdn.microsoft.com/mfp/2018/12/06/sysda-a-new-x-query-api/

it allows you to modify the x++ select statement using extensions