10-14-2010 05:35 PM
"I have checked this with one of our lead engineers and he has told me of the following process where you can map fields in the labor structure to a new table and you can then run your reports off that instead of the probsummary table.
Go to database dictionary and bring up the probsummary table. Double click on the labor structure which will open a popup window where you can enter a Attribute file name and unique Attribute. Add a file name in both fields, eg: laborattribute and laborunique. Click OK and OK again to exit the dbdict.
The laborattribute table will have the fields in a normal scalar fashion, ie: text, date/time, number etc. Not a blob/clob.
You can then report off of the new table from the rdbms. The unique id is also included in the new table, so you will have the ticket number."
02-28-2013 01:50 AM
Just wanted to raise this - great tip by Andy Plant. If you need to make reports by making queries to SQL database, this is essential to get data out from for example "clocks" table. We're tracking how long different assingment groups are holding the tickets...
I skip the thread every time 1) word "urgent" is used or 2) an old thread has been hijacked.