Administer > Stage server > Staging server utilities > stagingprop


Filter data published using the stagingprop utility

Filter 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 ("/").


Procedure

  1. 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.

  2. Filter data by change record:

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

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

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


Related tasks

List server-managed tables

Create a database table filter list

Related reference

stagingprop utility


+

Search Tips   |   Advanced Search