Knowledge Base - Getting Started Guide

Markersets filters

Basic filters

When you generate your markersets, you can use built in filters to further refine the displayed markers. For example :

  • Logged in users vs not logged users
  • Users from a particular access level
  • Entries from a specified category or group of category
  • ...

The built in filters are dependent on the current extension (CB, Sobi, ...) selected when you created the markerset.

Custom filters

In some cases you will be filtering your data by different custom fields. Each extension (CB, Sobi, ...) used to build the markerset has its own database structure and its own method of filter creation. There are controls to generate the filter query (field choice, operator choice, and condition). Note : in some case there is 2 query generators like in Sobipro.

geocode factory filter query generator

Bellow is a list of sample queries you can adapt following your needs. Note : only the bold text is replaced by your query filter, all other are the Geocode Factory regular internal queries, and don't reflect the exact code (it's just the query syntax).

You also could debug the filters following this procedure :

  • Enable the debug mode (see the how to use debug mode article)
  • Reload the map
  • You should now see a link over the XML file
  • Open this link in a new window
  • Now you should see more info about your error
  • If you cannot find the problem, please send us the debug output.

Filters for specific components

Filters for Community Builder

To understand how the filter is applied, see where and how the condition is added to the markerset query :

  • SELECT values FROM table WHERE conditions AND your_filter_here AND conditions

Regarding the CB database structure you can chain the different values using AND or OR operator : ((cb_field_2 = value) AND (cb_field_2 = value))

Filters for Jomsocial

To understand how the filter is applied, see where and how the condition is added to the markerset query :

  • SELECT user_id FROM table_fields WHERE your_filter_here

Regarding the Jomsocial database structure you cannot chain the different values.

Filters for Adsmanager

To understand how the filter is applied, see where and how the condition is added to the markerset query :

  • SELECT values FROM table WHERE internal_conditions AND your_filter_here

Regarding the Adsmanager database structure you can chain the different values using AND or OR operator : ((field_2 = value) AND (field_2 = value))

Filters for Sobipro

To understand how the filter is applied, see where and how the condition is added to the markerset query :

  • SELECT entries FROM table_fields WHERE your_filter_here

Regarding the Sobipro database structure you cannot chain the different values.

Filters for Sobi2

To understand how the filter is applied, see where and how the condition is added to the markerset query :

  • SELECT entries FROM table_fields WHERE your_filter_here

Regarding the Sobi2 database structure you cannot chain the different values.

Filters for Mosets Tree

To understand how the filter is applied, see where and how the condition is added to the markerset query :

  • SELECT values FROM table WHERE your_filter_here

Regarding the Mosets Tree database structure you can chain the different values using AND or OR operator for the base fields, and add a v. for the other fields : ((field_2 = value) AND (field_2 = value))

Filters for Jomsocial Event

To understand how the filter is applied, see where and how the condition is added to the markerset query :

  • SELECT entries  FROM fields WHERE  your_filter_here

Regarding the JS Events database structure you can chain the different values from the events using AND or OR operator : (( field_2 = value) AND ( field_2 = value))

Filters for JEvents

To understand how the filter is applied, see where and how the condition is added to the markerset query :

  • SELECT events FROM table WHERE your_filter_here

Regarding the JEvents database structure you can chain the different values using AND or OR operator : (( field_2 = value) AND ( field_2 = value))

Filters for Joomla contents

To understand how the filter is applied, see where and how the condition is added to the markerset query :

  • SELECT articles FROM table WHERE your_filter_here

Regarding the Joomla database structure you can chain the different values using AND or OR operator : ((field_2 = value) AND (field_2 = value))

Advanced custom filters

For advanced stuff, and for advanced samples, read the Specific extensions help chapter, there is several cases where we have helped customers for the filter creation.

Applies To

Geocode Factory 3