Skip to main content
Solved

What is the FBQL equivalent of BQL's SelectWindowed?

  • Nov 11, 2022 6:18 PM UTC
  • 3 replies
  • 220 views
  • Translate All

Forum|alt.badge.img+8

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

View original

3 replies

Shawn Burt
Jr Varsity I
Forum|alt.badge.img+1
  • Jr Varsity I
  • Answer
  • Nov 11, 2022 6:33 PM UTC

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

Translate

Forum|alt.badge.img+8
  • Author
  • Captain II
  • Nov 11, 2022 6:36 PM UTC

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!

Translate

Shawn Burt
Jr Varsity I
Forum|alt.badge.img+1
  • Jr Varsity I
  • Nov 11, 2022 6:40 PM UTC

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

Translate