Report - add a sort with a dot-walking field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2026 02:11 AM
Hello everyone !
I have a question about the configuration of a report based on the [goal] table. We would like to add a sort on a principal project field (u_rank), but the field is not proposed on the list, we only see date or datetime fields (see the screenshot). Do you know if this is the expected behavior ? and if yes, is there an explanation ?
Thanks a lot for your help,
Have a nice day,
Camille
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2026 02:18 AM
May be because of that field type.
what's the field type?
Did you check with some other field of same field type and see if it shows in Sort option?
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2026 02:35 AM
Hi Ankur,
This is a choice field, there is another choice field (close code) that does not appear.
I don't understand why choice type is not represented, do you have an explanation ?
Thank you !
Camille
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2026 02:33 AM
The fact that it is a 'u_'-field, means that it is custom. So without knowing more about it, it's impossible to answer your question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2026 03:19 AM
Hi Mark,
Thank you for your comment!
The field "u_rank" is a choice field with 70 occurences (value = 1---> 70) belonging to [pm_project] table.
If I have a look for another field that is not custom, for exemple the phase (String), I can’t find it either...
Except one or two, all field proposed have the date or datetime types.
Regards,
Camille