Big data selector system and method
View Patent ↗A graphical user interface (GUI) is disclosed that allows user to quickly find and select (assign) specific items from a large data source that is housed in the cloud. The GUI includes a first and second grid that display unassigned and assigned items, respectively. Each of the first and second grids allows the user to filter each grid by typing in the search criteria and forwarding the criteria to the server. Items in each of the first and second grids may be moved between the two grids to quickly change the assigned state of moved items.
1. A system comprising:
a server for storing a large collection of data sets accessed by a user through a computing device, the server including:
one or more server processors; and
a non-transitory computer-readable medium storing computer program instructions operable to cause the one or more server processors to perform operations comprising:
performing, in response to receiving from a client computing device a service call to request data items in a database, server side paging for the return of requested data items; and
returning, in response to receiving from the client computer device a service call to filter data items based on a filter criteria, the filtered items; and
the client computing device comprising:
one or more client processors; and
a non-transitory computer-readable medium storing a program having a graphical user interface (GUI) for controlling the retrieval of items from the server, the GUI including a first grid for unassigned items, a second grid for assigned items, and a dropdown control, the program for execution by the one or more client processors to perform operations comprising:
receiving, from a user via the dropdown control, a selection of a first table in the database;
initiating, based on the received selection of the first table in the database, a service call to the server to retrieve items in the first table;
populating the second grid with retrieved items from the first table;
receiving, from the user, input into a filter area of the second grid comprising filter criteria for the second grid;
initiating a service call to the server, the service call including the filter criteria input by the user in the second grid;
receiving, from the server, filtered items retrieved by the server from the first table;
updating the second grid to only display the received filtered items;
receiving, from the user, selection of one or more first selected items in the second grid;
receiving an indication from the user to deassign the one or more first selected items from the first table;
updating the second grid to remove the one or more first selected items;
updating the first grid to include the one or more first selected items in a pending area disposed proximate a top of the first grid above a pending items separator;
receiving an indication from the user to commit pending changes; updating the first grid to move all items from the pending area to a main portion of the first grid;
receiving, from the user via the dropdown control, a selection of a second table in the database;
initiating, based on the received selection of the second table in the database, a service call to the server to retrieve items in the second table;
populating the second grid with retrieved items from the second table;
receiving, from the user, selection of one or more second selected items in the first grid;
receiving an indication from the user to assign the one or more second selected items to the second table;
updating the first grid to remove the one or more second selected items;
updating the second grid to include the one or more second selected items in a pending area disposed proximate a top of the second grid above a pending items separator;
receiving an indication from the user to commit pending changes;
updating the second grid to move all items from the pending area to a main portion of the second grid.
2. The system of claim 1 , wherein the server comprises a cloud server.
3. The system of claim 1 , wherein the client computing device comprises a desktop computer.
4. The system of claim 1 , wherein the client computing device comprises a laptop computer.
5. The system of claim 1 , wherein the client computing device comprises a workstation.
6. The system of claim 1 , wherein the client computing device comprises a mobile electronic device.
7. The system of claim 1 , wherein the client computing device comprises a mobile phone.
8. The system of claim 1 , wherein the client computing device comprises a smart phone.
9. The system of claim 1 , wherein the client computing device comprises a tablet.
10. The system of claim 1 , wherein the client computing device comprises a touchscreen.