Customize System query "InventTransAdjustment"

Hi experts,

I want to customize the sys’s query “InventTransAdjustment

Scenario:

  • I want to add ProdTable to sys’s origin query “InventTransAdjustment

  • When I add ranges of ProdTable, The query will further filter ProdTable range, and else, it will have no effect on the query of the system.

Any one has simple solution to resole?

Thank all.

You can add a range of reference category field on InventTransOrgin (table in the query) and set the value to Production Or you join the ProdTable in \Classes\InventAdjTransactSelect\initQueryRun
But why do you want to restrict it only to production?

Hi Kranthi,
thank for your rep,
As your suggestion:
1st: add a range of reference category field
If I add range of reference category field on InventTransOrgin (table in the query), it’s not enough.
I also want to use range Pool (ProdPoolId) in table ProdTable.
2nd: join the ProdTable
Can you tell more about this way?
Thanks.

You can add a new data source(prodTable) to InventTransOrigin and join it by using InventTransId.

I tried add ProdTable to datasource, but If I use JoinMode:InnerJoin or JoinMode:OuterJoin–> It’s wrong results.
Is there a way when select the range of ProdTable to affect the filter results, and not select the range of ProdTable, the result stays the same as the system?

What issue do you have with inner join? Have you tried exists join?