Is there anyway to set the Kinetic Search Selection Option “Select All Maximum”? It defaults at 200 but the user has the option to increase it up to 5000. However, the value selected only applies to that search so the users has to set it each time.
You can set the Default Search Page Size in your sysconfig, You can edit your sysconfig
DefaultSearchPageSize value=“100” /
or use the Config Editor
Scott
This controls the number of records returned, not the amount allowed to be selected at one time.
It also does not do anything for the new UX since it will page indefinitely as you scroll.
True, but you can set a high number, I default is ours 1,000 to return a large set instead of the default 200
I do have the DefaultSearchPageSize value=“1000” in my sysconfig but this only applies to Classic menus and doesn’t change the Kinetic Search Select All Maximum
Interesting, We are starting on our UAT for 2022.2.x next Monday and we are going Live on Classic for everything so I have not noticed that, any screens with larger set of records are classic and using the 1,000 value.
But as Hannah stated with Kinetic UX’s lazy loading functionality overrides this value then and populates the next 200 records.
Scott
I’m not saying you should do this and if you’re cloud, you’re S.O.L. anyways, buuuuuuut SQL magic:
Use at your own risk; I’m not responsible for your database. Test in a non-production environment. Yadda, yadda, yadda.
This won’t change the visual of the field (it will still show 200), but as you gather enough records past the 200, it will select more. That all being said, the default 200 doesn’t reeaaallly seem to do much. If I remove that row from my DB, leave it at 200, scroll a bunch to load over 200 records, it still selects more. Do with this what you will.
INSERT INTO Ice.SysConfig (Company, Key1, Key2, Key3, SysCharacter01, SysRevID, SysRowID, TenantID, InstanceDefinition, DBHash, InstallationID)
VALUES ('','KineticMaxSelectAll','','','1000',DEFAULT,NEWID(),'','','',CONVERT(uniqueidentifier,'00000000-0000-0000-0000-000000000000'))
SELECT * FROM Ice.SysConfig
WHERE Key1 = 'KineticMaxSelectAll'
Thanks - we are in the
I do see if I leave the selection option at 200 but in the Search Results check the top box to select all…back on the Main Grid if I do a “Copy All” it copies 200. However, if I do an “export to excel” from the main grid I get 173 records. Very quirky
For us search is key for the New PO Suggestions menu and our users are not happy with the kinetic functionality.
Is it possible to set this in Application Studio, form by form, so each user doesn’t have to create a Kinetic personalization? Our finance folks want max records, so they don’t miss anything (although they could miss if there are over 5000 rows).
I don’t want to set 5000 site or company-wide, since most other users will be better off with infinite scrolling in chunks of 100.
You’re able to set the “Page Size” under Grid Model which I think controls the numbers of records displayed. But I think to do what you’re asking, you would need (2) different menus, correct?
Finance people would go to a specific menu where you’ve updated the default page size to 5,000. Everybody else goes to a menu where the default page size is… well… not customized, so they get the standard functionality.
Thanks, David. That did it! Since Finance is the only user for Chart Tracker, I made a customization layer for it, and assigned it in Menu Maintenance.
Now if I could only get grid columns ordered, hidden, unhidden, and widths adjusted in a layer. That’s a different thread…