AnsweredAssumed Answered

How to create report filter same as where IN in query

Question asked by Autchara Chaiprom on Jan 8, 2018
Latest reply on Jan 10, 2018 by André Lopes

I tried to create report to select lead from list of unique number (unumber_c)

When type in query should be like this:

SELECT first_name, last_name, unumber_c
FROM leads
JOIN leads_cstm ON id = id_c
WHERE unumber_c IN (
'123456',
'123457',
'123458',
...
..
.
)

 

But I cannot found IN condition in Report Wizard.

 

I easier way but too workload is add filter like below:

unumber_c = '123456' OR 

unumber_c = '123457' OR 

unumber_c = '123458' OR

...

 

Screenshot from report wizard:


 

a list of this number about 300 items, super crazy solution.

 

Do someone has smart way to do?

SugarPro 7.9.1.0

 

Thanks,

M

Outcomes