08-17-2015 11:03 AM
I wish to query SQL for them as opposed to searching through the SYS Configuration Report.
08-17-2015 11:17 AM
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.
08-18-2015 06:57 AM
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 |
08-18-2015 07:55 AM
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
08-17-2015 11:17 AM
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.
08-18-2015 06:45 AM
08-18-2015 06:57 AM
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 |
08-18-2015 07:55 AM
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
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.