query range start with 21000

(0) Share

Report

Posted on by MAKDAX2012_Ahmed

110

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

I have the same question (0)

All responses (8)

Answers (0)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi MAKDAX2012_Ahmed,

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

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

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()

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report

i have tried but i did not work

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MAKDAX2012_Ahmed 110 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No