Row Filter Selection Logic

Row Filter Selection Logic

When defining Row Filters in Orbit, you need to define the selection filters all the way up the hierarchy for consistent results and to avoid any errors.

To explain this, let's say you have a table structure of:

Households (Region)
|____ People (Income)
          |____ Bookings (Destination)

with an example variable on that table shown in brackets.

In other words Households to People is one-to-many
People to Bookings is one-to-many.

Supposing you have a user or a group of users who can only see records relating to a Household that is in the Region of the North West.

In this scenario, because Region is defined on the master table (Households) then you might think you can just add a single row filter selection of Region = North West defined on the Households table.

If you do this, then it will work to a fashion but any selections on URNs on the People or Bookings table will fail with errors similar to this:


Let's say you wanted to configure a user or a group of users so they can only see records relating to High Earners.
If you were to configure a selection on the People table using the Income variable and select the higher categories and then use this on your Row Filter definition:



then this would not apply any filters to the affected users.

To test this quickly:
Run an Audience count in Orbit
Look in the FastStats Service log file
You should have a JobType submitted of SIMPLERESULT



The problem will be shown in the Got messages when reading results entry
Make a note of the thread number (6 in the example above).
Look in the log directory for the fs32svr logs.

The following is reported in the fs32svrErr<date>-<thread number>.log:

[2026-05-20][11:27:03] **ERROR (2514) Error actioning request type=GlobalFilter action=define guid=b87e2c3e-8cd1-81e6-31c7-349912699596
[2026-05-20][11:27:15] **ERROR (2712) Resolve table 'People' is not valid in global filter specification
[2026-05-20][11:27:15] **ERROR (2712) Resolve table 'Households' has no global filter specification
[2026-05-20][11:27:15] **ERROR (2712) No valid global filter specifications
[2026-05-20][11:27:15] **ERROR (2712) Error in global filter specification
[2026-05-20][11:27:15] **ERROR (2514) Error actioning request type=GlobalFilter action=define guid=32c02a71-5899-85f4-40fa-1409512066af [2026-05-20][11:27:16] **ERROR (2712) Resolve table 'People' is not valid in global filter specification
[2026-05-20][11:27:16] **ERROR (2712) Resolve table 'Households' has no global filter specification
[2026-05-20][11:27:16] **ERROR (2712) No valid global filter specifications [2026-05-20][11:27:16] **ERROR (2712) Error in global filter specification
[2026-05-20][11:27:16] **ERROR (2514) Error actioning request type=GlobalFilter action=define guid=b02b41e1-6cac-8100-5c85-f2c10cf3540e

To get this to work, you would need three selections of:
1. People who have a high income value using the Income variable
2. Households with People that have a high income value using the Income variable
3. Bookings for People with a high income value using the Income variable



As another example, supposing you want to filter the system to Bookings that have a Destination of Australia.

The Destination resides on the Bookings table and so you need 3 filter selections in your row filter:
  1. Bookings selection of Destination = Australia
  2. People selection of People who have made a booking to Australia
  3. Households selection of People who have made a booking to Australia






    • Related Articles

    • Audience reference not displaying on tile filters

      It was reported by several users (on version 2.0.0) that when an existing audience was added as a filter to a tile and saved, after a refresh or reload the underlying filter was being shown as undefined. Steps to repeat: Create a dashboard Add a tile ...

    • User Filter No 'Add Filter' Button

      This is a system setting in Orbit to add or remove user filters in Dashboards. You do need Orbit administrator rights to be able to make this change. If this setting is turned on a user will be able to add their own user filters from any of the ...

    • PS Unable to find the versioned file

      In Q3 23 we changed the default stance on versioned selections to error if it can not find the latest version available for the selection that is being used in the Campaign. To revert this back to use versioned files in the db, please set this in the ...

    • Counting specific days \ day types between 2 dates.

      A user asked it was possible to count the number of working (weekdays) between 2 dates. They had considered the function Datediff() within an expression but realised this simply counts the total number of days between 2 dates. Our suggestion was to ...

    • Import a list of dates and URNs and run a selection to find the date in the system with the same URN and previous to the one in the list.

      A client asked us for a method of importing a list of URNS and Dates, into an existing FastStats system, and then to suggest a method to compare the imported date to other dates for the same URN in order to then provide the previous date attached to ...