Skip to main content
Solved

Load data in Grid or Form with PXSelector

E
Freshman I

Hi, I’m new with Acumatica, and I have a question about load data with a PXSelector. I need add the data in some fields of the Grid and other in a form, but I don’t know how to do that. Help, please. 

Best answer by Naveen Boga

Hi @emmanuelmeza62  When you wanted to display the Form and Grid values in the selector, then you should use the Inner Join  (SEARCH2<>) in the selector and provide the Fields, which you wanted to display.

Below is the sample example for your reference and hope this helps!!

 

  #region SelectorBranchID
        [PXDBString(255, IsUnicode = true, InputMask = "")]
        [PXUIField(DisplayName = "Branch", Enabled = false)]

        [PXDefault(typeof(Search<Branch.branchCD, Where<Branch.branchID, Equal<Current<AccessInfo.branchID>>>>))]

        [PXSelector(typeof(Search2<Branch.branchCD, InnerJoin<BAccount, On<BAccount.bAccountID, Equal<Branch.bAccountID>>>>),
                    typeof(Branch.branchCD), SubstituteKey = typeof(Branch.branchCD), DescriptionField = typeof(BAccount.acctName))]
        public string SelectorBranchID { get; set; }
        public abstract class selectorBranchID : BqlString.Field<selectorBranchID> { }
        #endregion

 

View original
Did this topic help you find an answer to your question?

4 replies

deebhane
Semi-Pro I
Forum|alt.badge.img+1
  • deebhane
  • Semi-Pro I
  • 62 replies
  • March 2, 2022

hi @emmanuelmeza62 

Below are few links that would help you to understand on the PXSelector 

PXXelector syntax 

PXSelector and Dirty Read - Acumatica Developers Blog

PXSelector example 

PXSelector for custom table | Community (acumatica.com)

PXSelector Quick search 

Acumatica Filtering PXSelector witth quick search - Stack Overflow

 

Please let us know if your looking for something specific. 

 

 

Deebhan Hari E
Chris Hackett
E
D
3 people like this
  • Chris Hackett
    Chris Hackett
  • E
    emmanuelmeza62
  • D
    danielagus17
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3393 replies
  • March 2, 2022
emmanuelmeza62 wrote:

Hi, I’m new with Acumatica, and I have a question about load data with a PXSelector. I need add the data in some fields of the Grid and other in a form, but I don’t know how to do that. Help, please. 

 

Can you please confirm that that the fields, which you wanted to show are saved in the database, in other words, all are bound fields?

Naveen B
Chris Hackett
E
2 people like this
  • Chris Hackett
    Chris Hackett
  • E
    emmanuelmeza62
E
Freshman I

@Naveen B  Hi, yes the data are saved in the database, but I don’t know how to show the data in other fields,for example, in this case I want put the data “numLicencia” in the region with the same name.

 

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3393 replies
  • Answer
  • March 3, 2022

Hi @emmanuelmeza62  When you wanted to display the Form and Grid values in the selector, then you should use the Inner Join  (SEARCH2<>) in the selector and provide the Fields, which you wanted to display.

Below is the sample example for your reference and hope this helps!!

 

  #region SelectorBranchID
        [PXDBString(255, IsUnicode = true, InputMask = "")]
        [PXUIField(DisplayName = "Branch", Enabled = false)]

        [PXDefault(typeof(Search<Branch.branchCD, Where<Branch.branchID, Equal<Current<AccessInfo.branchID>>>>))]

        [PXSelector(typeof(Search2<Branch.branchCD, InnerJoin<BAccount, On<BAccount.bAccountID, Equal<Branch.bAccountID>>>>),
                    typeof(Branch.branchCD), SubstituteKey = typeof(Branch.branchCD), DescriptionField = typeof(BAccount.acctName))]
        public string SelectorBranchID { get; set; }
        public abstract class selectorBranchID : BqlString.Field<selectorBranchID> { }
        #endregion

 

Naveen B

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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