web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Query range of strictl...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Query range of strictly lower than 0 for a real field

(1) Share

Report

Report

Posted on by Jason0810M

8

Hello,

I have to apply a range on a specific field for a form data source such that the list of records displayed must have the field value < 0.

I have tried looking in the SysQuery and SysQueryRangeUtil classes but found nothing.

How can this be implemented?

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

You can use '<0' as a range value.

Was this reply helpful? Yes No
Jason0810M 8 on at

Like (0)

Report

Can I use strfmt("%1..", 0) as well?

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

Like (1)

Report

That would mean "from zero to unlimited", but you want "lower than zero".

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

You can make use to this old comment from Martin for the same.

https://community.dynamics.com/forums/thread/details/?threadid=ac31ed7f-4f4b-4234-9598-47f66864e67e

Was this reply helpful? Yes No
Jason0810M 8 on at

Like (0)

Report

Sorry I meant strfmt("..%1", 0). But '<0' works fine as well.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 451 Most Valuable Professional

#2

André Arnaud de Cal... 428 Super User 2025 Season 2

#3

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans