IF in query object

(1) Share

Report

Posted on by LH-07011645-0

Hello colleagues

Is it possible in a Query to use something like IF with data item link?

For example

To make a query which takes out Item Ledger Entries from T32 for the last week,

IF source type = Customer Then DataItemLink Source No to Customer Name in Table 18 Customers

IF source type = Vendor Then DataItemLink to Source No Vendor Name in Table 23 Vendors

It seems to me that this is not the way a query works, but maybe others can suggest something else which can achieve this

Thanks Louise

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

Vahid Ghafarpour 12,202 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!

I'd create two separate queries, one for customer-related entries and another for vendor-related entries and use a codeunit or a page to run both queries and combine the results based on the source type!

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,392 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Data Item Links - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,930 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

This is different from TableRelation, where you cannot set an IF(<Conditions>. And you cannot create two DataItems at the same level in Query.

So the only way is to create two different queries as VaHiX mentioned.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Query does not support conditional statement.

Your option is:

- Create 2 queries

- Create 1 query without the customer or vendor name. when you use the query in code, you add a code to go and fetch the customer or vendor name based on the source no.

Was this reply helpful? Yes No
LH-07011645-0 71 on at

Like (0)

Report
Copy link

Link copied!

Thank you all for your quick responses!

You have saved me a lot of time.

Best

Louise

Was this reply helpful? Yes No