# Rollback to previous changeset

**URL:** https://forum.liquibase.org/t/rollback-to-previous-changeset/7789
**Category:** General Discussion
**Created:** [February 13, 2023, 2:30pm UTC](https://forum.liquibase.org/t/rollback-to-previous-changeset/7789 "2023-02-13T14:30:38Z")
**Posts on this page:** 2
**Page:** 2

<div class="post-metadata">

### Author: ![daryldoak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/daryldoak/32/764_2.png) [@daryldoak](https://forum.liquibase.org/u/daryldoak)
#### Post date: [January 28, 2025, 3:26pm UTC](https://forum.liquibase.org/t/rollback-to-previous-changeset/7789/22 "2025-01-28T15:26:13Z")

</div>

Sure, that makes sense. I’m unable to edit those posts at this time.

---

<div class="post-metadata">

### Author: ![wshaklee](https://avatars.discourse-cdn.com/v4/letter/w/977dab/32.png) [@wshaklee](https://forum.liquibase.org/u/wshaklee)
#### Post date: [October 30, 2025, 1:01am UTC](https://forum.liquibase.org/t/rollback-to-previous-changeset/7789/23 "2025-10-30T01:01:03Z")

</div>

Hello,

I’m following this syntax for SQL but is this possible for XML files. In our installation we use masterchangelog.xml that contains changeset definitions that point to a changelog file that is also XML. The change log file contains a list of files one for tables, procedures, views, procedures etc. In each of these files is the include statement for the .sql file that gets executed. I’m not seeing a way to reference a file for a rollback that’s inside a file that is included in a changelog XML that’s defined in a masterchangelog XML.  
example master-changelog

\<?xml version="1.0" encoding="UTF-8"?\>

\<databaseChangeLog

```
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9

     http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">

<changeSet author="itw-?-test-1B-start" id="itw-?-test-rollback-1-4.1.0-start">

    <tagDatabase tag="itw-?-test-rollback-1-4.1.0-start"/>

</changeSet>

<include file="changelogs/test-rollback-1B/db-changelog-ddl\_?\_table_ddl.xml"/>

<include file="changelogs/test-rollback-1B/db-changelog-ddl\_?\_table_dml.xml"/>

<include file="changelogs/test-rollback-1B/db-changelog-ddl\_?\_procedure.xml"/>

<include file="changelogs/test-rollback-1B/db-changelog-ddl\_?\_streams.xml"/>

<include file="changelogs/test-rollback-1B/db-changelog-ddl\_?\_task.xml"/>

<include file="changelogs/test-rollback-1B/db-changelog-ddl\_?\_view.xml"/>

<changeSet author="itw-?-test-rollback-1B-start" id="itw-?-test-rollback-1-3.1.0-end">

    <tagDatabase tag="itw-?-test-rollback-1-4.1.0-end"/>

</changeSet>

```

sample changelog

 ![image](https://us1.discourse-cdn.com/flex020/uploads/liquibase1/original/2X/6/69b2bc985f44fbc8218217a577336fe715037943.png)

sample changlog file

\<?xml version="1.0" encoding="UTF-8"?\>

\<databaseChangeLog

```
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9

 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">

<include file="databasechanges/?/procedures/ddl_sp_rollback_proc_1.sql" />

<include file="databasechanges/?/procedures/ddl_sp_rollback_proc_2.sql" />

<include file="databasechanges/?/procedures/ddl_sp_rollback_proc_3.sql" />

<include file="databasechanges/?/procedures/ddl_sp_rollback_proc_4.sql" />

<include file="databasechanges/?/procedures/ddl_sp_rollback_proc_7.sql" />

```

The ? is just a character string with the application name.

Thanks for any assistance anyone can offer.

```
<include file="changelogs/test-rollback-2/db-changelog-ddl_dhub_table_ddl.xml"/>

<include file="changelogs/test-rollback-2/db-changelog-ddl_dhub_table_dml.xml"/>

<include file="changelogs/test-rollback-2/db-changelog-ddl_dhub_procedure.xml"/>

<include file="changelogs/test-rollback-2/db-changelog-ddl_dhub_streams.xml"/>

<include file="changelogs/test-rollback-2/db-changelog-ddl_dhub_task.xml"/>

<include file="changelogs/test-rollback-2/db-changelog-ddl_dhub_view.xml"/>

<changeSet author="itw-datahub-test-rollback-2-start" id="itw-datahub-test-rollback-2-1.0.0-end">

    <tagDatabase tag="itw-datahub-test-rollback-2-1.0.0-end"/>

</changeSet>

```

[Previous page](https://forum.liquibase.org/t/rollback-to-previous-changeset/7789.md?page=1)