Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

query range start with 21000

Posted on by 102

Hello,

how can i filter form data source all customer start with 21000.

how can i write expression on query range custAccountNum start with 2100 in AOT query object.

BR

Ahmed

 

  • Martin Dráb Profile Picture
    Martin Dráb 225,783 Super User on at
    RE: query range start with 21000

    Please try "21000*".

    By the, way, the query you use in the first screenshot isn't what you asked for. You wanted values starting with 21000, but your filter will return values containing 21000.

  • MAKDAX2012_Ahmed Profile Picture
    MAKDAX2012_Ahmed 102 on at
    RE: query range start with 21000

    i want result like this

    pastedimage1610089713974v1.png

     Bur when i use AOT query range 2100*  with display menu i get this type of result.

    the result  is 

    pastedimage1610089985790v2.png

    and also get error

    Error executing code: FormRun object does not have method 'okPressed'.

    Stack trace

    (C)\Classes\FormRun\okPressed
    (C)\Classes\QueryRun\prompt
    (C)\Classes\QueryRun\run

  • MAKDAX2012_Ahmed Profile Picture
    MAKDAX2012_Ahmed 102 on at
    RE: query range start with 21000

    i am using query in Display menu to open filtered form like past worker in HRM module 

    pastedimage1610088753267v1.png

  • Martin Dráb Profile Picture
    Martin Dráb 225,783 Super User on at
    RE: query range start with 21000

    You want 2100 followed by any number of characters (for which you can use * wildcard), therefore the value should be 2100* (not "2100*"?).

  • MAKDAX2012_Ahmed Profile Picture
    MAKDAX2012_Ahmed 102 on at
    RE: query range start with 21000

    i have tried but i did not work

    pastedimage1610088437730v1.png

  • MAKDAX2012_Ahmed Profile Picture
    MAKDAX2012_Ahmed 102 on at
    RE: query range start with 21000

    Thanks but i want to use query expression in AOT query range

    pastedimage1610088380287v1.png

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: query range start with 21000

    Hi Ahmed,

    If you use query range expression or select statement ,please check this blog:

    community.dynamics.com/.../using-not-like-in-x-select-statements-and-query-ranges

    Another way is to use SysQuery::valueLike()

    01641.PNG

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: query range start with 21000

    Hi MAKDAX2012_Ahmed,

    For all customers starting with "2100', have you tried the expression "2100*"?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans