query range start with 21000

(0) Share

Report

Posted on by MAKDAX2012_Ahmed

106

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.

Ahmed

All responses (8)

Answers (0)

Martin Dráb 231,983 Most Valuable Professional on at

Like (0)

Report

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 106 on at

Like (0)

Report

RE: query range start with 21000

i want result like this

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

the result is

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 106 on at

Like (0)

Report

RE: query range start with 21000

i am using query in Display menu to open filtered form like past worker in HRM module
Martin Dráb 231,983 Most Valuable Professional on at

Like (0)

Report

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 106 on at

Like (0)

Report

RE: query range start with 21000

i have tried but i did not work
MAKDAX2012_Ahmed 106 on at

Like (0)

Report

RE: query range start with 21000

Thanks but i want to use query expression in AOT query range
Blue Wang on at

Like (0)

Report

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()
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: query range start with 21000

Hi MAKDAX2012_Ahmed,

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