Determine list of selected partitions on Exact Online

Question

When I set the list of active partitions in Data Hub using:

select code 
from   systemdivisions 
where  city='Rotterdam'

to all customers in Rotterdam, the next queries will retrieve data across all customers.

In Invantive Control I can see in the GUI which partitions are selected, but this is not visible in Data Hub since it is a command line tool.

How can I determine afterwards which companies have been selected as a partition?

Answer 1

Use the following query:

select code
,      label
,      short_name
from   systempartitions@datadictionary 
where  is_selected = true
order
by     code

to retrieve the currently selected partitions.