Restricted queries with 4D for iOS

With 4D v17 R4, embedding and displaying filtered content in your 4D for iOS app is a piece of cake! With this R-release, you’ll be able to filter the data to be displayed in your mobile app.

A new Data section is available to let you filter the data sent to mobile devices. In previous versions, you were limited to a subset of tables and fields. Now you can control which records are sent – independently – for each iPhone or user.

For example, you might want to synchronize only invoices from the last year or customers of a specific sales team, filtered by region.

To ease development and testing, the new Data section allows you to define the data source the data comes from (Current data file or Production server data file) and to specify if you want to regenerate data automatically each time you build your app or generate it manually.

In the 4D for iOS documentation this Data section is documented to help you easily define your first filters.

A tutorial is also available to explain query filters based on user’s information. At the end of the tutorial, you’ll be able to display content depending on the login used. As you can see in the images below, which show the final results of the tutorial, the app content is filtered based on the “In Progress” contracts AND according to the salesperson that is logged in.

Only Michelle Simpson’s In Progress contracts are sent to the iPhone, drastically reducing synchronization time and data volume.

Happy filtering!


David Azancot
• 4D for iOS Product Owner •David Azancot joined the 4D Product team as a Product Owner in 2017. He's in charge of writing the user stories and translating them into functional specifications. His role also includes making sure that feature implementations meet customers' needs.David graduated with an MBA in Marketing, Internet and Mobility from the Leonard De Vinci Institute and began his career in 2011 with a mobile start-up company, later acquired by Madvertise (a mobile marketing group). Passionate about mobile interfaces, he was the natural choice to develop interactive mobile ad formats for the group in 2015. In parallel, David has been developing his own iOS and Android applications since 2012.