05-21-2013 07:51 AM
I"m trying to create a custom query to get documents with a keyword type for Doc Description. For different document types I have different Doc Description keyword type names (ex. FA_SAP_Doc_Description for SAP Document Types, FA_TitleIV_Doc_Description for Title IV Document Types, FA_Loans_Doc_Description for Loan document types, etc.). I just want the different keyword types for doc description to be in one column. Because each of these keyword types only appear on the document type it belongs to.
Right now if I write a custom query it comes out like this.
Student ID | Document Type | FA_SAP_Doc_Description | FA_TitleIV_Doc_Description | FA_Loans_Doc_Description
1234657 SAP Document SAP Appeal Statistics
1234568 Title IV Doc Title IV return form
1231234 Loans Doc Bank of America Loan App
etc.
I want it to appear like this (create a generic column called Doc Description)
Student ID | Document Type | Doc_Description
1234657 SAP Document SAP Appeal Statistics
1234568 Title IV Doc Title IV return form
1231234 Loans Doc Bank of America Loan App
etc.
I think with SQL and using CASE WHEN ELSE I could get this to work but you can't seem to do that with Custom Query.
Does anyone have any suggestions?
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.