User information query

Now let's filter our app content depending on the account manager's login email address (user information):

• Go to the Data section.
• Right-click in the Filter query field to make Field, Comparators and Operators buttons appear.
• Click on the Operators button and select AND.
• Now define the user information you want to get from the database method, :email.
• Remember to validate the query by clicking on the Validate button. If not, you won't be able to build your app.

Status = 'In Progress' & manager.Email = :email 

The query will filter data depending on the In Progress status AND the Account manager's email address (accessible from the AccountManager table thanks to the Many-to-One relation on the manager's name).

NOTE

• A user icon is displayed on the right of each table when a user information filter is applied to it.
• As soon as a query is based on user information and validated, you need to edit the Mobile app authentication method. To do so, right-click on the Edit authentication method button to open the database method edition window.

Add the following line in the database method:

$response.userInfo:=New object("email";$request.email)

This will allow retrieving the manager's login email address and displaying data depending on that criteria.

Now if you build your app and enter "michelle.simpson@mail.com" as login email, you'll find all of Michelle Simpson's "In progress" contracts.