0

May I know what is the difference between "row" and "first" in layman?

Josh

December 02, 2021 03:19

None

Follow

Hi,

Although I have taken some session of Jet reports triaining.

I still can't figure out when to use "rows" and "first".

Can someone advise?

Thank you!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  CascadiaDataworks April 18, 2022 16:23

  First should be used when there is one and only one answer.  The result in the worksheet will always only return one answer, regardless of how many results there are.
  1. What is the name of customer 8675309?
  2. What is the due date of invoice 12345?
  3. What the name of GL Account 44000?

  Rows is used when there could be one or more answers AND you need to create a list of all values. This will create a new row with each value found in the result.  This could be 0, 1 or many results.
  1. Which customers are located in Portland, Oregon?
  2. Which invoices have a due date of 04/02/22?
  3. Which GL Accounts are balance sheet accounts? 

  If you end up using a First instead of Rows, Jet will always return the first value it finds that meets the filter criteria.  On the flip-side, even though Rows could return one value, it is super inefficient to use Rows when First should be used.

  Edited by CascadiaDataworks May 11, 2022 19:57