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
JOIN leads_cstm ON id = id_c
WHERE unumber_c IN (
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?