3 new fields
Posted: 05. Jun 2024, 15:15
Hello everyone,
I hope someone can help me. We have a new ArticleTypeService DD called UD_MOT, and we have created Service Portfolios based on UD_MOT. Now I want to add three more fields. It should show me the creator of this service, the last changes (date), and the last person who changed it for documentation purposes.
I have now done this in the ActivityClassBase with this query:
SUBQUERY (SPSActivityClassUnitOfWork as work, MAX(work.CreatedDate), work.[Expression-ObjectID]= base.[Expression-ObjectID])
However, this only works for queries and when the journal is available within the ticket. But I want these fields to appear in our service preview and in the query column "Last changed on," "Last changer," and "Creator."
How can I implement this?
Thanks for the help!
I hope someone can help me. We have a new ArticleTypeService DD called UD_MOT, and we have created Service Portfolios based on UD_MOT. Now I want to add three more fields. It should show me the creator of this service, the last changes (date), and the last person who changed it for documentation purposes.
I have now done this in the ActivityClassBase with this query:
SUBQUERY (SPSActivityClassUnitOfWork as work, MAX(work.CreatedDate), work.[Expression-ObjectID]= base.[Expression-ObjectID])
However, this only works for queries and when the journal is available within the ticket. But I want these fields to appear in our service preview and in the query column "Last changed on," "Last changer," and "Creator."
How can I implement this?
Thanks for the help!