How to identify full constituents in RE NXT Backup file

Options

We have a situation where demoted records are stored in list management. I want to exclude these records from reporting when loading data from the backup file. Is there a field in the backup file that indicates whether a record is a "full constituent" or not?

For example:

We created a record for Smith (Constituent ID: 12345, System Record ID: 987654).

When the record is demoted, the Constituent ID and System Record ID fields still retain their values?

How can I differentiate between active and demoted records in the backup file?

Comments

  • Alex Wong
    Alex Wong ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @Venky Immadisetty
    This depends on what backup file are you talking about.

    When you say “list management” i think of Omatic's List Management, is that what you talking about?

    If by “backup” you mean SQL database backup, then in the RECORDS table, there is a field call “is_constituent” which -1 is constituent 0 is non-constituent.

Categories