Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
7 subscribers
Views
1833 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Hi Forum I asked this question a couple of weeks ago with no reply, h
lincolnf454
over 10 years ago
Hi Forum
I asked this question a couple of weeks ago with no reply, hopefully someone can help me out this time
On a standard grid, is there a maximum amount of rows that a grid can handle on a form? I imagined that the grids have the same capability as reports or paging grids with handling numerous records (ie being able to select different pages of the report), but this is not the case for standard grids. We have the issue of a user not seeing all records in the grid with about 30 contacts in total and only about 20 being shown on the form. Any help would be greatly appreciated
...
OriginalPostID-101501
OriginalPostID-101501
Discussion posts and replies are publicly visible
0
Sathya Srinivasan
Appian Employee
over 10 years ago
what is the source of the data that's populating the grid? Is it from a query rule/paging info that you are parsing or a standard set of pv! of type multiple or report?
The first place I'd check is the data source. Reports have no of rows to return set. Check that as well to make sure its not restricted if that's your source.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
lincolnf454
over 10 years ago
Hi Sathya, thank you for your reply. The source is from a query rule which then populates into a pv! of type multiple, and then I use this pv! for the default value of the grid.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 10 years ago
is your query rule taking a paging-info as a parameter which might possibly be restricting the no of records returned?
Can you monitor the return of the query rule to verify if it has all the records returned or just the first 20?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
lincolnf454
over 10 years ago
My query rule is pulling straight from a SQL database, no paging info included.
I have investigated the returned results and only the first 10 are passing from the query to those pv!'s. It's great that I've figured out that the grid isn't the problem but my query must be at fault. Thanks Sathya
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 10 years ago
So you are not using Query Rules but you are using Query Database smart service to execute your SQL. In that case, the smart service has a default cap on the no of records returned to 10. You can configure this in your custom.properties file. Your original message said that you were able to see 20. Are you seeing 10 or 20?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
lincolnf454
over 10 years ago
Sorry for being unclear Sathya. I am only seeing 10 entries, so it most likely is a cap in the custom.properties file. And yes I got confused between a Query Rule and a Query Database smart service. Should I try using a query rule to default into the grid instead of using the Query Database smart service?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel