Setting Multiple Filters

Follow

Abhay Mattson

February 17, 2017 20:56

I will try to be as simple and detailed as possible.

I am trying to apply multiple filters based on a selected Image.

I have 9 images with a level number, 1-9.
I have 9 images with a picture of Classes
I have a list of spell names.

I can filter easily with Spell Class (Wizard) Equals X and it will filter all the spells that are under the Wizard Column and show them in the list. Great.

What I need to do is also filter the level. (3) So the list only shows level 3 spells and Wizard.

So basically I need to filter level and the class of spell at the same time with 2 images. Then be able to select a different level or class and have it filter those on the list page. However I want to have all this done on 1 or 2 pages instead of hundreds. I was thinking a set command? Not sure how to implement it.

0

• 

  Abhay Mattson February 17, 2017 20:57

  I wanted to add, I know I can do 2 filters on 1 page, which would work however I am not sure how to make it dynamic so I can change the values of the filters with the image selected.

  0

  Comment actions Permalink
• 

  Goyo Gomez February 17, 2017 20:58

  Hi:

  https://www.bigmarker.com/mobincube/Dynamic-filters-and-relational-databases-in-Mobincube

  Hope it helps.

   

  0

  Comment actions Permalink
• 

  Abhay Mattson February 17, 2017 21:00

  Thank you for the reply, I have seen that and it is not what I need exactly.  My issue is changing the Filters on the same page or did I miss something?

  0

  Comment actions Permalink
• 

  Goyo Gomez February 17, 2017 21:08

  Hi.

   

  Set command allows you to store values in variables, and in databases fields, but I do not know how this would be useful for you.

  This should work, if you selected an element in a list view before using the set action:

  Set (databasename.fieldname) = value

  But when the app is updated those changes made with set will be erased and used the database from the new binary.

  0

  Comment actions Permalink
• 

  Abhay Mattson February 17, 2017 21:10

  That would set 1 value.  I need to essentially have filters that change based on image click.

  0

  Comment actions Permalink
• 

  Abhay Mattson February 17, 2017 21:14

  Set (databasename.fieldname) = value   Unless there is a way to set value to a filter instead of declaring it?

  0

  Comment actions Permalink
• 

  Goyo Gomez February 17, 2017 21:45 (Edited February 17, 2017 22:22)

  You can use variables or other fields in a filter, for example:

  Field1 equal (databasename.fieldname)

  or

  Field1 includes {cookie.myvar}

  or

  Field1 includes {language}

  0

  Comment actions Permalink
• 

  Abhay Mattson February 17, 2017 22:18

  Right so I have for example 4 filters. 

   

  Sname equals (MWDB.Wizard) 

  Sname equals (MWDB.Warlock)

  Sname equals (MWDB.Mage)

  Sname equals (MWDB.Sorcceror)

   

  They all work perfect independently.  However I have 4 images on the same Detail View.  An image of a Wizard Warlock, Mage and Sorcerer.  I want to be able to click the wizard image which will be a Go to Screen Spell List and show the wizard spells.  I would also want to hit the Warlock on the same page which takes the same path. Go to Screen but with the Warlock filter not the Wizard. etc etc.

   

  0

  Comment actions Permalink
• 

  Abhay Mattson February 17, 2017 22:20

  I can make this work with individual screens, but I have 9 classes and 10 filters.  I am trying to avoid 90 screens.

  0

  Comment actions Permalink
• 

  Goyo Gomez February 21, 2017 17:16

  we continue in the ticket you created....

  0

  Comment actions Permalink

Please sign in to leave a comment.