PXSelectJoin is a method of the Acumatica Framework that can be used to retrieve data from multiple tables using join operations. This method is a part of the PXSelect class, and it is commonly used in Acumatica development.
Example 1:
PXSelectJoin>>>.Select(Base);
In this example, the PXSelectJoin method is used to retrieve data from the Customer and Contact tables, where the Customer.bAccountID equals the Contact.bAccountID. The InnerJoin keyword is used to specify that only records that have matching values in both tables will be returned. The Base parameter is used to specify a reference to the current graph (i.e., the page or graph where the code is running).
In this example, the PXSelectJoin method is used to retrieve data from the SOLine and SOLineSplit tables, where the SOLineSplit records that have matching values in both tables are returned. The LeftJoin keyword is used to specify that records from the SOLine table will be returned even if there are no matching records in the SOLineSplit table. The Where clause is used to filter the records based on the values of the Current objects.
Package Library: The PXSelectJoin method is a part of the Acumatica.Framework.dll library, which is part of the Acumatica ERP package.
C# (CSharp) PXSelectJoin - 37 examples found. These are the top rated real world C# (CSharp) examples of PXSelectJoin extracted from open source projects. You can rate examples to help us improve the quality of examples.