Skip to main content

How to Query the Maximum Value of the id Column in the Data Model

The system default data identifier (_id) is a string type, and its sorting rule is based on the order of ascii codes.

To query the maximum value of the id column, you need to sort the id column in descending order and retrieve the first record.

const { data } = await models.post.list({
  filter: {
    where: {},
  },
  orderBy: [
    {
      _id: "desc", // Sort by _id in descending order
    },
  ],
  pageSize: 1, // Page size. It is recommended to specify this value. To set a different value, it must be used in conjunction with pageNumber. Both parameters must be specified to take effect.
  pageNumber: 1, // Page number
  getCount: true, // Enable to get total count.
});

Similar Issues​

  • How to get the maximum value of the id column in the data model?
  • How to query the maximum value of id in the data model?
  • What are the code samples for querying the maximum value of the id column in the data model?
  • How to obtain the maximum value of id through the data model?
  • What method should be used to query the maximum value of id in the data model?
  • How to find the maximum value of the id column in the data model?
  • What are the steps to query the maximum value of the id column in the data model?
  • How to implement the query for the maximum value of the id column in the data model?
  • What are the specific steps to obtain the maximum value of the id column in the data model?
  • What are the techniques for querying the maximum value of id in the data model?