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, ... Smartlist --- OR Funct...

Finance | Project Operations, Human Resources, ...

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:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Gavin 2,508 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Henri2021 5 on at

Like (0)

Report

Hi Gavin,

Yes, I did. It does not work. I know it is so odd!

Was this reply helpful? Yes No
Henri2021 5 on at

Like (0)

Report

How can I add the screen shot here?

Was this reply helpful? Yes No
Suggested answer

agaber on at

Like (0)

Report

Hello-

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

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 503 Most Valuable Professional

#2

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

#3

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans