Access to previous and next records

Question

I'm looking for a way to make it possible to page through a list of records from the view of a single record - that is, to add in BACK and NEXT buttons at the bottom of a single record view rather than returning to the list to reselect the next.
I understand from previous posters that this may be possible if you can access the list's index of the selected record, then decrement or increment into a local variable so your BACK and NEXT buttons will take the user to the correct record.
I have saved the queried list of records to a local variable. How does one access the index values of the records in that variable? Should I instead work from a read-only grid? fv!item will give me the entire record but no value I can reliably decrement or increment to get its neighbors, and fv!identifier will give me its unique identifier, but as records are constantly added and deleted that is also unreliable.

mikes0011 · Accepted Answer

I think I've located what I needed with the WHERECONTAINS function - if I can pass in the fv!identifier as the value it should be able to return to me the array index.

This doesn't sound very efficient - it sounds as if you'll be querying the entire data set just for the sake of iterating one back and one next. Instead you should run two separate surgical queries, tuned to return just the primary key ids of the previous row and next row (as i described in my previous comment).

When running my initial record query should I take care to sort by ID to get an accurate result?

You have some flexibility here. In general I'd suggest you sort on whatever field you use for your record list's primary sort (if something other than primary key).

Here's a sample of the query I mean, note that here i've sorted by primary key, but you can change this to whatever you're sorting by (last name, etc).

a!queryEntity(
  entity: cons!my_entity,
  query: a!query(
    pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: 1,
      sort: a!sortInfo(
        field: "primaryKey", 
        ascending: if(ri!fetchingPrevious, false(), true())
      )
    ),
    filter: a!queryFilter(
      field: "primaryKey",
      operator: if(ri!fetchingPrevious, "<", ">"),
      value: ri!currentPrimaryKey
    )
  )
).data.primaryKey

mikes0011 · Answer

Can you clarify - are you trying to add the ability to go to the previous / next record from a certain record's Summary View page? If so, I think it's doable but I don't think any button will do it - you'd need to use a link.

Is the fv!identifier the DB primary key? If so, in your record interface you could simply query single entries from the DB where the primary key is one less than the current (for previous) and one greater (for next), and simply use those queried values in your a!recordLink calls on the interface.

Sign up

Login with SSO

Login to the community

Login with SSO