Skip to main content
Answer

How to get a specific data from PXSelect ?

  • November 13, 2023
  • 2 replies
  • 286 views
I
Freshman I
Forum|alt.badge.img

I am using public PXSelect<POLine> polineview to get POLine data. But i need to know how to get data from polineview with a where condition to get a specific data row rather than getting all the data from the table. Hope anyone can help ?

Best answer by Naveen Boga

@ifelix  You can use the PXFieldScope() to get the specific column data. Below is the article to help you to work with PXFieldScope()

 

https://asiablog.acumatica.com/2016/06/restricting-list-of-fields-selected.html#:~:text=Using%20PXFieldScope%20you%20can%20specify,fields%20from%20the%20selected%20tables.

 

 

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • Answer
  • November 13, 2023

@ifelix  You can use the PXFieldScope() to get the specific column data. Below is the article to help you to work with PXFieldScope()

 

https://asiablog.acumatica.com/2016/06/restricting-list-of-fields-selected.html#:~:text=Using%20PXFieldScope%20you%20can%20specify,fields%20from%20the%20selected%20tables.

 

 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Chris Hackett
RohitRattan88
darylbowman
Captain II
Forum|alt.badge.img+15

This really depends upon your use case, but unless I’m missing something, filtering a BQL query is not difficult. Have you taken the application developer training?

Daryl ⚡Freelance Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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