web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Larger than operator f...
Microsoft Dynamics CRM (Archived)

Larger than operator for a text field in Advanced Find filter

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I need to create a filter in Advanced Find on a single line text field such as employeeID (a single text field), which use the operator larger than. But I don't see any comparison operators available. Is there any work around to resolve this?

Thanks in advance,

Hao

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Hi Hao Tian,

    Yes..

    It will not apply to a single line of text, you need a numbering, countable ones, like whole number (integer).

    Since they are not a really number even though you put ID:

    ID 1 = 12341234

    ID 2 = 12341235

    ID 3 = 12341236

    ID 4 = 12341237

    ID 5 = 12341238

    It will still possible to have A12341234 right, like passport number got Letter + number.

    So this field type, the single line of text is not a numbering field.

    So these are workarounds:

    1. If possible if you want to get all employee with ID "is greater or larger than 1234" you can use contains 1234, begin with..

    But this is only applicable if only you have a structured and ordered numbering. You cannot just say more than 1000

    You need to have the specific prefix.

    2. Export the all result then use Excel to find it. Well using Excel you can manipulate many things, you can convert it to numbering

    3. Create a field and copy the value, updating using programmatically method or excel import wizard might be possible.

    Hope this helps.

    Thanks.

  • Community Member Profile Picture
    Community Member on at

    Thanks Aileen,

    our employee ID is in the format LLLD (three letters followed by a digit), and there are more then 20,000 records in Contact entity. So the export to excel won't work because we cannot change anything on the SQL server side.

    It seems that I'll have to run a Scribe DTS to export the data.

    Thanks again,

    Hao

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Hao Tiean,

    I see, you want to update the records...

    Wow, you have Scribe..It's lot better and faster...

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans