Which code snippet retrieves the first 10 entries from the abc_book table as CDT objects and returns the total count?

Which code snippet retrieves the first 10 entries from the abc_book table as CDT objects and returns the total count?

• A. a!queryEntity( entity: cons!ABC_DSE_BOOK query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10, ) ) fetchTotalCount: true )
• B. a!queryEntity(entity: cons!ABC_DSE_BOOK, query: a!query(pagingInfo: a!pagingInfo(startIndex: 0, batchSize: 10)), fetchTotalCount: true)
• C. a!queryEntity(entity: cons!ABC_DSE_BOOK, query: a!query(pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 10)), fetchTotalCount: false)
• D. a!queryEntity(entity: cons!ABC_DSE_BOOK, query: a!query(pagingInfo: a!pagingInfo(startIndex: 2, batchSize: 10)), fetchTotalCount: true)

Answer: (A)

To get the first 10 entries as CDT objects and also know how many total records exist, you page the query from the first record and request the total count. In Appian, the first page starts at startIndex 1 with a batchSize of 10, and you enable total counting with fetchTotalCount: true. This combination returns the first 10 records from the abc_book CDT as objects and includes the overall total number of matching records. That’s why the snippet using the entity cons!ABC_DSE_BOOK, pagingInfo with startIndex: 1 and batchSize: 10, and fetchTotalCount: true is the correct choice. Using a startIndex of 0 would not align with Appian’s 1-based paging for the first page, startIndex: 2 would skip the first page, and fetching the total count as false would omit the total number of records.

To get the first 10 entries as CDT objects and also know how many total records exist, you page the query from the first record and request the total count. In Appian, the first page starts at startIndex 1 with a batchSize of 10, and you enable total counting with fetchTotalCount: true. This combination returns the first 10 records from the abc_book CDT as objects and includes the overall total number of matching records.

That’s why the snippet using the entity cons!ABC_DSE_BOOK, pagingInfo with startIndex: 1 and batchSize: 10, and fetchTotalCount: true is the correct choice. Using a startIndex of 0 would not align with Appian’s 1-based paging for the first page, startIndex: 2 would skip the first page, and fetching the total count as false would omit the total number of records.