Share
ReportHello,
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
You’re offline. This is a read only version of the page.
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
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.
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
i am using query in Display menu to open filtered form like past worker in HRM module
You want 2100 followed by any number of characters (for which you can use * wildcard), therefore the value should be 2100* (not "2100*"?).
i have tried but i did not work
Thanks but i want to use query expression in AOT query range
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()
Hi MAKDAX2012_Ahmed,
For all customers starting with "2100', have you tried the expression "2100*"?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (