Alpha Software Blog



Data Shown in a List Made Easy For Apps-Powerful Geography Searches

  These recent videos show how easy it is to incorporate 'location aware' searches on data shown in a list into your mobile and desktop web application development efforts using Alpha's upcoming product There are many use cases. For example a mobile application for sales people would show all customers that are within (say) 1, 10 and 15 miles of the sales person’s current location.

UX Component: List Control - Geography Searches

If the List control is based on a SQL database that supports the Geography data type (SQL Server, MySQL, Oracle, DB2 all do), then you can perform 'geography' searches on the data in the List. For example, you can find all records that are within (say) 10 miles of your current location. The 'current location' can be automatically supplied by the device. Alternatively, you might want to know which records are within a specified radius of a certain point (that you can specify by latitude/longitude value), or by address. In addition, when the results of the search are displayed in the List you might want to group the data in 'logical' groups. For example, the first group might be 'Records within 1 mile of your current location', the next group might be 'Records between 1 and 5 miles from your current location' and so on. In this video we show how this is easily done.  

UX Component: List Control - Geography Searches for Mobile App Development

Searching data to show records that are near the current location of a mobile device is an extremely common need in mobile applications and mobile app development situations. For example, the well know iOS application, Yelp, shows all restaurants that are near you or Flixster shows you all the movie houses that are within 1, 5, 10, 15 miles of where you are. In this video we build on the example show in the previous video and we show how a simple mobile application can be built that does a 'geography' search on data in a List control. Powerful but easy and quick to do.  
Prev Post Image
Alpha Anywhere: Using "Sub-Themes" to Style Controls in mobile apps
Next Post Image
OERCA lets zoological institutions improve the lives of marine mammals

About Author

Richard Rabins
Richard Rabins

Co-founder of Alpha Software, Richard Rabins focuses on strategy, sales, and marketing. Richard also served as CEO of SoftQuad International from 1997 to 2001, when it owned Alpha. In addition to his 30 years with the company, Richard played a key role as co-founder, and served as president and chairman of the Massachusetts Software Council (now the Massachusetts Technology Leadership Council), the largest technology trade organization in Massachusetts. Prior to founding Alpha, Richard was a project leader and consultant with Information Resources, Inc. (IRI), and a management consultant with Management Decision Systems, Inc. Richard holds a master's degree in system dynamics from the Sloan School at MIT, and a bachelor's degree in electrical engineering and master's degree in control engineering from University of the Witwatersrand in Johannesburg, South Africa. He has served on the boards of Silent Systems, Legacy Technology and O3B Networks, and is co-founder of Tubifi www.tubifi.com.


The Alpha platform is the only unified mobile and web app development and deployment environment with distinct “no-code” and “low-code” components. Using the Alpha TransForm no-code product, business users and developers can take full advantage of all the capabilities of the smartphone to turn any form into a mobile app in minutes, and power users can add advanced app functionality with Alpha TransForm's built-in programming language. IT developers can use the Alpha Anywhere low-code environment to develop complex web or mobile business apps from scratch, integrate data with existing systems of record and workflows (including data collected via Alpha TransForm), and add additional security or authentication requirements to protect corporate data.

Comment