function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
developer03developer03 

Architecure question

Hi,

Last year when our company implemented Salesforce CRM we needed a custom application which would allow users to search 40,000 records of a custom object and have paging & sorting abilities. At that time we implemented this using SControl as it was the only option.

Because of the amount of data that needs to be processed and displayed by the browser/Javascript it was not a great surprise when post-implementation survey revealed this SControl was the source of greatest dissatisfaction amongst Salesforce CRM users.

Now that Apex Code is available and VisualForce is on the horizon what is the best solution for this application? Keep in mind sometimes the search can easily return more then 2,000 records which need to be paged and sorted.

Thanks for help :)
mtbclimbermtbclimber
I guess I'd be interested to know why our standard search capabilities are not sufficient for your needs before recommending the right solution for you.
developer03developer03
Our company provides students placement services for Australian Universities.

So a user knows that they need to find "Accounting" course. If they enter just this keyword they might get 5,000 records so they need to get more precise results. Therefore they need to specify which University but they may not know the exact name of the University so we have drop down. Most of them would not know which state this University is in so there is a drop down for states. Most of them would not know the name of campus of University so there is a dependent drop down with University campuses. They may only want courses from Spring/Autumn semester or they may want courses offered on both semesters so they is a drop down for this as well.

These are some examples which can not be easily done using standard search.
mtbclimbermtbclimber
Sounds like that would fit in nicely with our Search Filter Fields feature, no?