AppMachine Help Center

How can we help you?

Follow

Filtering on a Datalist Options and Examples

Filter options

So, you've included your own data into your app using either the Excel or Web Service building block. However the amount of data being presented to the user is might be too large  large and you would like to filter the list.

In this short how-to article we will walk you through the few simple steps you have to complete in order to filter your list with the “Filter Expression” which you can find in the Advanced Tab of your Web Service or Excel block.

Options

Operand

Name

  >=

  Greater Or Equals

  <=

  Smaller Or Equals

  =

  Equals

  !=

  Not Equals

  %

  Contains

  >

  Greater

  <

  Smaller

   

  AND

  condition 1 AND condition 2 have to be true

  OR

  condition 1 OR condition 2 have to be true

{AM:NOW}

 show items that are on the current device date (date ="{AM:NOW}")

am_distance 

Show items based on a user location in meters


We’ve added two screenshots with every filter. First one is the list without the filter and the second is the list after applying our filter. Let’s go!We have taken the demo app “Movies” to demonstrate the filter possibilities.


You can filter the data for example by using the statement ‘City = London’.

  • Remember that you can only apply filters on “fields” of your Web Service or Excel.
  • You can “combine” as many filters as you like in one expression

 

1. GreaterOrEqual >=

Filter

Description

vote_average >= '7'

Shows all movies with an vote_average of 7 or higher. Ant-Man and Magic Mike XXL are being filter from the list.

  

  

2. SmallerOrEqual >=

Filter

Description

vote_average <= '7'

Shows all movies with an vote_average of 7 or lower. Ted 2 and Inside out are being filter from the list.

  

 

3. Equals =

Filter

Description

title = Minions

Shows the movie with the title ‘Minions’

 

4. NotEquals !=

Filter

Description

release_date != '2016-05-27'

Shows the movies when the release_date is not “2016-05-27”. In this case. X-Men: Apocalypse is being filtered from the list.

  

 

5. Contains %

Filter

Description

title % ‘The’

Shows the movies when the title contains the word “The

  

 

6. Greater >

Filter

Description

vote_count > 500

Shows the movies when the vote_count is higher than 500 votes.

  

  

7. Smaller <

Filter

Description

vote_count < 200

Shows the movies when the vote_count is lower than 200 votes.

  

 

8. COMBO AND - Contains % AND EqualsOrHigher >=

Filter

Description

release_date % "1985" AND vote_average >= "6"

Shows the movies when the release_date contains 1985  AND the vote_average equals 6 or higher. Star Wars &  Mad Max are being filtered from the list.

  

 

9. COMBO OR - Contains % OR EqualsOrHigher >=

Filter

Description

release_date % "1985" OR vote_average >= "7"

 Shows the movies when the release_date contains 1985  OR  the vote_average equals 7 or higher. The terminator & Ghostbusters are being filtered from the list.

  

 

Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Markus

    hi, fellows, i tried several things, how can i filter the list to show only upcoming dates from this list? date >= {device:currentdate} doesn't work, any ideas? greets

  • Avatar
    Johnny Boersma

    Hi Markus,
    You can try : date >= {am:now}.
    {device:currentdate} is not used for filtering a list.

    Kind regards,
    Kind regards,

  • Avatar
    marcocarvalho

    date>= "{AM:NOW}"

  • Avatar
    naifzhr

    Hello,
    I'm trying to use "filter expression" to show the user the events in the city that the user in Or it shows only the events that is 25 mails near to the user . I tried to use this [ City % "{user:location}" } but it did not work. please can you help me in that.