web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Add emptystring() cond...

Microsoft Dynamics AX (Archived)

Add emptystring() condition to view

(0) Share

Report

Report

Posted on by Community Member

Hi Everyone

I would like to create a view from table, and the condition was (user7=''') in SQL.

May i know how to add this condition to my view datasource? Is it add a range or any other advice?

I had tried to add the sysquery::emtystring() command but i dunno where to place it.

Please advice

Thank You

Best Regards

Kuan Yi

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Martin Dráb 235,914 Most Valuable Professional on at

Like (0)

Report

RE: Add emptystring() condition to view

If you look inside SysQuery::valueEmptyString(), you will see it simply returns "" (quotes). That's what you can use as the value of your range.

Two dots are used for a range of values (e.g. 1..10 for "one to ten").

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Add emptystring() condition to view

Navigate the view object from AOT, in Metadata node, open the data source and add new ranges.

In Range property, select the field in Field property and put two dot ".." in Value property. In Dynamics AX, two dot ".." is the same as empty string in filtering.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Syed Haris Shah 9

#2

Mea_ 4

#3

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans