Hi, i´d like to build a view which also gives me the information stored within the call´s history. However i cant find a suitable search paramater in the Criterion search box or the available view fields.
hi, you can get the history via sql-query to SD database.
here's an example:
select hist.hsc_created, hist.hsc_subject, per.per_name from itsm_servicecalls sc inner join ITSM_HISTORYLINES_SERVICECALL hist on hist.HSC_SER_OID = sc.ser_oid inner join itsm_persons per on per.per_acc_oid = hist.reg_createdby_oid where sc.ser_id = 1234 -- servicecall id order by hist.hsc_created
This undocumented feature was found long ago by someone else and posted here in the forums but I was not able to find the original thread.
Now, if you use sd_dataform, you might be able to use all of the History fields and display them on a list based on the criteria you used by using the -ListAll parameter.
Also, on Alexander K.'s suggestion, I prefer to use SD's generated Views for reporting instead of querying the operational tables, the Views for reporting have user-friendly names, especially if you are not too familiar with the SD database...