Which tables and/or indices contain the values for the "unrestricted query" options per doctype?

[Rob_Keberdle]

  I wish to query SQL for them as opposed to searching through the SYS Configuration Report.

[Scott_McLean · Accepted solution]

That setting is part of the itemtypeflags value in the hsi.doctype table. This bitwise value contains many of the document type settings. I don't know which bit corresponds to which setting, but you could probably figure it out by changing the setting and examining how the value changes.

[Mike_Saville · Accepted solution]

The following query will return all document types that have "No Warning"

select itemtypename, itemtypegroupname from hsi.doctype dt join hsi.itemtypegroup dtg on dtg.itemtypegroupnum = dt.itemtypegroupnum where (itemtypeflags & 4) = 4

[Scott_McLean · Accepted solution]

That setting is part of the itemtypeflags value in the hsi.doctype table. This bitwise value contains many of the document type settings. I don't know which bit corresponds to which setting, but you could probably figure it out by changing the setting and examining how the value changes.

[Rob_Keberdle]

I suspected that might be the case, but I was hoping someone already figured it out how to translate the values. It appears to be outside of my capabilities 🙂

[Mike_Saville · Accepted solution]

The following query will return all document types that have "No Warning"

select itemtypename, itemtypegroupname from hsi.doctype dt join hsi.itemtypegroup dtg on dtg.itemtypegroupnum = dt.itemtypegroupnum where (itemtypeflags & 4) = 4

[Ansley_Ingram · Accepted solution]

Hi Rob,

The Configuration reports in Report Services (which it appears that you own) offer the same information that the SYS Configuration Reports do but in a format that's a bit easier to search through than a flat text file. The information you are looking for - both the result set and the SQL can be found in the reports. 

Hope that helps.

Ansley