I’ve done a few searches but I can’t seem to locate the equivalent.
Solved
What is the FBQL equivalent of BQL's SelectWindowed?
Best answer by Shawn Burt
isn’t the SelectWindowed under the View class within the SelectFrom?
InventoryItem item = SelectFrom<InventoryItem>
.Where<InventoryItem.inventoryID.IsEqual<@P.AsInt>>
.View.SelectWindowed(graph,startRow,totalRows,parameter);
+1isn’t the SelectWindowed under the View class within the SelectFrom?
InventoryItem item = SelectFrom<InventoryItem>
.Where<InventoryItem.inventoryID.IsEqual<@P.AsInt>>
.View.SelectWindowed(graph,startRow,totalRows,parameter);
It could be. :) I’m typically coding within the Customization Project screens vs VS Studio so I don’t get the benefit of Intellisense and a search of the Framework documentation turned up almost nothing.
Thank you!
+1Give it a try. If you have more questions please let me know.
My sample kind of sucked as it would only return one row anyway. but in the end if you call View.SelectWindowed from your FBQL results
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.