Skip to main content
Answer

What is the FBQL equivalent of BQL's SelectWindowed?

  • November 11, 2022
  • 3 replies
  • 152 views

Forum|alt.badge.img+7

I’ve done a few searches but I can’t seem to locate the equivalent.

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);

3 replies

Shawn Burt
Jr Varsity I
Forum|alt.badge.img+1
  • Jr Varsity I
  • Answer
  • November 11, 2022

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);


Forum|alt.badge.img+7
  • Author
  • Captain II
  • November 11, 2022

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!


Shawn Burt
Jr Varsity I
Forum|alt.badge.img+1
  • Jr Varsity I
  • November 11, 2022

Give 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