Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Find a sample mapping (SD 4.5)

Highlighted
William_157
Senior Member

Find a sample mapping (SD 4.5)

I need help with that:

I need find a sample mapping of the table column to field;

WorkOrder.TITLE := Request Subject

WorkOrder.DESCRIPTION := Request Description

WorkOrder.CREATEDTIME := Request Created Date

WorkOrder.DUEBYTIME := Request Due by Date

WorkOrder.COMPLETEDTIME := Request Completed Date

WorkOrder.REQUESTERID := Requester
(FOREIGN KEY CONST with AaaUser.FIRST_NAME)

WorkOrderStates.OWNERID := Technician
(FOREIGN KEY CONST with AaaUser.FIRST_NAME)

WorkOrderStates.CATEGORYID := Category
(FOREIGN KEY CONST with CategoryDefinition.CATEGORYID)

WorkOrderStates.SUBCATEGORYID := SubCategory
(FOREIGN KEY CONST with SubCategoryDefinition.SUBCATEGORYID)

WorkOrderStates.ITEMID := Item
(FOREIGN KEY CONST with ItemDefinition.ITEMID)
2 REPLIES
The Pike
Honored Contributor

Re: Find a sample mapping (SD 4.5)

It is unlikely that you'll find a readily available 'sample mapping' of any sort here.

If I had to find out what table.column maps to what field in SD, I would spend some time looking at the tables and would also generate views for reporting in case the field labels have been altered.

What are you trying to achieve? There may be more suitable options rather than manipulating the database directly, which, by the way is discouraged and not supported by HP.

The Pike
William_157
Senior Member

Re: Find a sample mapping (SD 4.5)

thanks
//Add this to "OnDomLoad" event