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
- To use a custom list to filter data by database table:
- Create a file containing one or more lists of database tables.
- 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.
- For each change record to publish, insert the same positive integer value into the STGFILTER column for the change records in the STAGLOG table.
- Specify the -filter parameter along with the positive integer value when you run the stagingprop utility.
Related tasks
Create a database table filter list
Related reference