CODEWITHSUNDEEP
exact-onlineinvantive-sqlinvantive-data-hub
RS Finance
RS Finance

Reputation: 224

Determine list of selected partitions on Exact Online

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?

Upvotes: 2

Views: 46

Answers (1)

Guido Leenders
Guido Leenders

Reputation: 4262

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.

Upvotes: 1

Related Questions