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?

Guido Leenders · Accepted Answer · 2017-09-11T09:53:41.320

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.

edited Sep 11 '17 at 09:53

answered Sep 08 '17 at 08:46

Guido Leenders

`select code, label, short_name from systempartitions@datadictionary where is_selected = true` Gives a more readable output. – RS Finance Sep 11 '17 at 09:52
Yes, that is a more nicely laid out column list. I will change answer. – Guido Leenders Sep 11 '17 at 09:53

1 Answers1