Database Schema
I have located the database schema for SupportDesk PLus, but would to have the schema for SupportCenter Plus. It appears there are more tables in SupportCenter Plus.
As mentioned in a previous post, I am working with Crystal to generate reports. One of the fields I want to include was recently added through your last hotfix, service pack 3, ver 5008. You've know allowed user defined fields to be added to notifications. The field I added to my notification is coded $UDF_CHAR1. This is now working properly in our notifications. Now I want to add this field in a Crystal report. The only table I have found a field named UDF_CHAR1 is in the WORKORDER_FIELDS table. But this field is returning an empty result in my report.
My problem may be in how I have the tables linked. The schema would help with resolving this issue.
Thanks
David
As mentioned in a previous post, I am working with Crystal to generate reports. One of the fields I want to include was recently added through your last hotfix, service pack 3, ver 5008. You've know allowed user defined fields to be added to notifications. The field I added to my notification is coded $UDF_CHAR1. This is now working properly in our notifications. Now I want to add this field in a Crystal report. The only table I have found a field named UDF_CHAR1 is in the WORKORDER_FIELDS table. But this field is returning an empty result in my report.
My problem may be in how I have the tables linked. The schema would help with resolving this issue.
Thanks
David