Get first characters from job code

(1) Share

Report

Posted on by criztina

Hi, I'm creating a report to list projects and one of the parameters is the Department Group code responsible for the project, however this wasn't specified in any field, it can only be found in the project No, the first two characters, so I'm not sure how to extract those characters and make them populate a filter in the report request page, I was thinking on using a query but I can't find a way to get a substring from a field, my other option would be creating an enum and enter the codes manually which I don't think would change frequently. Any advice would be appreciated!

Categories:

Dynamics 365 general

All responses (3)

Answers (0)

criztina 47 on at

Like (0)

Report

Get first characters from job code

Sure, we are using the Person Responsible field in the Job Card.
Waed Ayyad 6,556 Super User 2024 Season 2 on at

Like (0)

Report

Get first characters from job code

Hi,

Do you mean your issue is resolved? Can you share field name in order to help other who will face this case in the future?

Thanks,

Waed Ayyad
criztina 47 on at

Like (1)

Report

Get first characters from job code

Never mind, there is a field with the code I need. Leaving the question as I can't find an option to delete it and probably it might be useful for someone else.