Create list of records without pre-loading any records?

[georgechen]

Hi folks

In new module is there a way to create a list of records based on a certain table without pre loading the records? (please find attachment for illustration)   This is kind of annoying when all the records are pulling out; I can set a filter condition there which outputs no records, but my clients would like to leave the default filter empty.

I even tried to create a new report (View / Run) as a List Report, however the pre-loading records list is still loading all records.

Any advise?

Thanks,

George

[Mark Stanger]

I think the best you could do is show a list with only 1 row.   You can create a new module of type (URL (From Arguments)) and add something like this (changing the table name of course) to the 'Arguments' field.

incident_list.do?sysparm_force_row_count=1

The 'sysparm_force_row_count' parameter can limit the rows returned, but it won't limit it to anything less than 1.

[georgechen]

Thanks Mark.   This does help in fetching only one record via the argument parameter.     I will be finding the page name of a list layout.

Regards,

George

[Jim Coyne]

The List Filter module type might be what you are looking for.   It basically displays a blank list view page:

Click on the filter icon to open up and build your query:

I usually create modules called "Search from List View" with this module for my clients.

[georgechen]

Thanks Jim. The List Filter looks great, but all records are still pulling out upon the module loading.