Solved

Creating a dataview based on a custom field

  • 15 February 2022
  • 1 reply
  • 316 views

Userlevel 7
Badge +5

I know that I can do what I want with custom fields but I’m wondering if there’s a way I can do this with a dataview.

I’ve added Contract Item to Cases. The Contract Item is one of the contract detail items based on the Case Contract field. No problems there.

I want to display some field values from the Contract Detail record and from some attributes associated with the Contract Detail’s recurring item (which is a non-stock item record).

I was starting with my graph extension and was going to add a simple data view along the lines of:

  public PXSelect<ContractDetail
      ,Where<ContractDetail.contractItemID
          ,Equal<Current<CRCase.usrContractItemID>>
          ,And<ContractDetail.contractID
            ,Equal<Current<CRCase.contractID>>
          >
      >
      >  CurrentContractItem;

But CRCase doesn’t contain usrContractItemID since that field comes from my DAC extension.

Can I create a data view this way in my graph extension?  Or do I have to create the data view with a parameter and then somehow refresh the data view after I have retrieved the case record or updated the contract item no field?

icon

Best answer by Naveen Boga 16 February 2022, 02:48

View original

1 reply

Userlevel 7
Badge +17

Hi @ddunn  usrContractItemID is extension DAC filed of CRCase? 

If yes, you can mention your extended DAC name instead of CRCase, like below.

public PXSelect<ContractDetail,Where<ContractDetail.contractItemID , Equal<Current<CRCaseEXT.usrContractItemID>>, And<ContractDetail.contractID
, Equal<Current<CRCase.contractID>>>>> CurrentContractItem;

 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved