Skip to content
Blog of Yuriy Zaletskyy

Dev Request

Get Insights into your Inbox weekly

Tag Cloud

  • Acumatica
  • MS SQL
  • Report Designer

Post List

  • Adding Grid Pagination to Standard Acumatica Screens (Classic & Modern UI)

  • Validating XML and Excel Imports in Acumatica

  • Building an AI Part 1: The Core Framework

  • Acumatica Financial Report with Dynamic Date Range Columns

  • Repeatable Vibe Coding for Acumatica: An 8-Step Playbook

  • One View, Two Grids: Migrating a Classic UI Pattern to Modern UI

  • Exploring Mobile Layout Elements in Acumatica 2026 R1

  • Implementing Asynchronous Operations in Acumatica 26R1

  • Multiple Implementations of a Generic Graph Extension in One Graph in Acumatica ERP 2026 R1

  • How to Add Fields to an Existing Grid with placeAfterProperty

Copyright © 2026

How To Get Top 1 Record From Db In Acumatica

28 April 2015
Hello everybody, today I want to share with you one trick that sometime can be useful. Imagine, that you constructed some BQL query and want to get only one record from db with ommiting others or in other words if you need TOP 1. For this purpose you can use SelectSingle method that generates SQL...
Read more on How To Get Top 1 Record...

Privacy policy | Cookie settings