Query Table Entry Active/Inactive Status

Jared Blumer

How does one go about querying if an Attribute table entry is active or inactive within a Constituent query?

Alan French

I've never come across a way to query on that from within RE, though you could do it if you've got access to SQL Server and can write your own queries there.


To see which entries are active/inactive, you'd have to go into Config > Tables and take a look at the list. I don't find that list particularly clear, as there's not very much difference visually between the active entries in black and the inactive ones in grey, but there is an option to filter out the inactive ones. Perhaps I just have rubbish eyes but I would prefer to have the inactive ones in a different colour.