Filtering data published using the stagingprop utility


Filtering allows to you to selectively publish updates from the production-ready data to the production data. The stagingprop utility allows you filter data by tables, by change record, or a combination of both.

Filtering data by tables

The -scope parameter of the stagingprop utility filters data by table. You have four options to scope the publication of data at the table level:

_all_

All production-ready data is published to the production server.

_site_

Only the tables containing site data are published to the production server.

_merchant_

Only the tables containing merchant data are published to the production server.

s

Only defined database tables contained in the list s are published to the production server. The list is in a file specified by the -configfile paramter. You can specify multiple lists by separating the lists with a slash character ("/").

To use a custom list to filter data by database table:

  1. Create a file containing one or more lists of database tables.

  2. Specify the -scope and -configfile parameters when you run the stagingprop utility.


Filter data by change record

The -filter paramater of the stagingprop utility filters data by change record.

To filter data by change record:

  1. For each change record you want to publish, insert the same positive integer value into the STGFILTER column for the change records in the STAGLOG table.

  2. Specify the -filter parameter along with the positive integer value when you run the stagingprop utility.

 

Related tasks


Listing server-managed tables
Create a database table filter list

 

Related Reference


stagingprop utility