Home› Service Manager

Workitems (MA RA) sort

Oleg_OliinykOleg_Oliinyk Customer IT Monkey ✭
in Service Manager
I created my own sql request. I want to get MA and RA in order as on Cireson. Which table stores the sort for table ([ServiceManager].[dbo].MTV_System$WorkItem$ServiceRequest) or ([ServiceManagement].[dbo].[WorkItem])

Best Answer

  • Billy_WilsonBilly_Wilson Member Ninja IT Monkey ✭✭✭✭
    Answer ✓
    Hi Oleg,

    The order is actually stored in the Activity table itself. so for [ServiceManager].[dbo].[MT_System$WorkItem$Activity$ManualActivity], the field is [SequenceId_644EB7B4_745F_8E69_5695_833D7AFD28A0]. so if you do a join of the Activity tables use this field in your ORBER BY DESC statement. 

Answers

  • Billy_WilsonBilly_Wilson Member Ninja IT Monkey ✭✭✭✭
    Answer ✓
    Hi Oleg,

    The order is actually stored in the Activity table itself. so for [ServiceManager].[dbo].[MT_System$WorkItem$Activity$ManualActivity], the field is [SequenceId_644EB7B4_745F_8E69_5695_833D7AFD28A0]. so if you do a join of the Activity tables use this field in your ORBER BY DESC statement. 
Sign In or Register to comment.