News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP forum Smartlist --- OR Funct...

Microsoft Dynamics GP forum

Suggested answer

Smartlist --- OR Function --- Multiple Values

(0) Share

Report

Report

Posted on by Henri2021

5

Hi all,

Here is what I need.

Record begins with: 270

Record begins with: 860

How can I have an OR function and ask Smartlist to bring up all the records to see these two items?

I had no success by trying all the possibilities: [270][860] or using comma or semi-colon or so!

It seems that Smartlist does not have this ability unless I alter my own SQL script by saying location = 270 OR loctaion = 860

Any thoughts on this?

Categories:

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

agaber on at

Like (0)

Report

RE: Smartlist --- OR Function --- Multiple Values

Hello-

You need to mark "Use Rich formatting" first and then you should be able to copy a screenshot in the Forum thread:
Henri2021 5 on at

Like (0)

Report

RE: Smartlist --- OR Function --- Multiple Values

How can I add the screen shot here?
Henri2021 5 on at

Like (0)

Report

RE: Smartlist --- OR Function --- Multiple Values

Hi Gavin,

Yes, I did. It does not work. I know it is so odd!
Gavin 2,333 on at

Like (0)

Report

RE: Smartlist --- OR Function --- Multiple Values

Hi,

Have you tried changing the search type to "Match 1 or more". I've found this works for me.

Hope this helps

Thanks

Gavin

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2

Martin Dráb 228,137 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans