CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Why is this string not working?

edited Aug 13, 2013 10:54AM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered ✓
I've converted a filter to SQL - I have a large number of email addresses that I need to report off of (see below). I am receiving this error message: Error getting drill information: SELECT "- Account Custom Attributes".PICK_1 saw_0, "- Account Custom Attributes".PICK_0 saw_1, Contact."Contact ID" saw_2, Contact."Contact Last Name" - this continues. What am I doing wrong here?
Contact."Email Address" IN (‘rmuller@uphs.upenn.edu’, ‘rbennett@redbox.com’, ‘claude.bialas@mac.com’, ‘michikot@iadb.org’, ‘sbeard@heidrick.com’, ‘robert.goodwin@ligocyte.com’, ‘etluxury@yahoo.com’, ‘luttrellmr@pella.com’, ‘ngchoonpeng@gmail.com’, ‘abdullah.zargis@egen.com.bd’, ‘rsiemer@tocounsel.com’, ‘ferhat.demir@surat.com.tr’, ‘sheilang@amtek.com.sg’, ‘nicole.grover@quantum.com’, ‘lhermouet@athyriumcap.com’, ‘tahra@arifootball.com’, ‘rgarr@skillpath.com’, ‘ssinger@bbandt.com’, ‘jy.lee@nettium.net’, ‘melanie.m.garger@irscounsel.treas.gov’, ‘luca.laurienzo@ny-management.com ‘, ‘brandlg@mot.gov.il  ‘, ‘manuel.gutierrez@kohler.com’, ‘jonathan.cunningham@jetblue.com’, ‘kent_bassett@vfc.com’, ‘max.meister@ludwigmeister.de’, ‘michelle.ann.roberts@owenscorning.com’, ‘ben.worley@networkrail.co.uk’, ‘zqing@capital8.com.sg’, ‘roysubhasis@yahoo.com’, ‘bluciocc@gmail.com’, ‘hussein_zurgani@zueitina.com’, ‘tomasz.pajak@darr.pl’, ‘peter.hynes@chinookum.com’, ‘contact@bvdbeverage.com’, ‘pcarbone@pritzkergroup.com’, ‘hyper-sub@hyper-sub.com’, ‘ramzi.rinaldhi@garuda-indonesia.com’, ‘gregory.fossey@camoplastsolideal.com’, ‘juan@onehealthmedical.com’, ‘ozer@atc.us.com’, ‘sheetal.patel@markit.com’, ‘alaydibd@hotmail.com’, ‘neffjessica@firestonebp.com’, ‘hnickerson@jdrf.org’, ‘dalmoaibed@aeg-me.com’, ‘ rnicholl@moog.com’, ‘richard.fisher@unite-group.co.uk’, ‘bpierce@newenglandinnocence.org’, ‘charles_yeo@bio-rad.com’, ‘sven.undeland@orexo.com’, ‘pgosavi@flyjetsky.com’, ‘bwolins@ilsco.com’, ‘ben.monson@primenri.com’, ‘chris.russell@macquarie.com’, ‘charli2535@aol.com’, ‘cormond@olympuspartners.com’, ‘chris.riely@moelis.com’, ‘tg.hatem@cds-mc.com’, ‘nicolae.lungu@econsulting.md’, ‘ahabib@alhilalbank.ae’, ‘james.cooper@imiplc.com’, ‘robin@connectsgroup.com’, ‘s.quinn@elsevier.com’, ‘g.seilkhanov@salamworld.com’, ‘minihan@gmail.com’, ‘jane.potts@uk.bureauveritas.com’, ‘kataoka@nria.com’, ‘cheryln.kelly@bms.com’, ‘jan@armsrx.com’, ‘rosalie.malone@fadedenterprises.com’, ‘indranil.bagchi@intel.com’, ‘hs.gupta@sonalika.com’, ‘psim@capasia.com’, ‘sujata.varadharajan@sunovion.com’, ‘autumn.mcfann@kdmc.kdhs.us’, ‘dsarang@denaliworldwide.com’, ‘bcook@jmpsecurities.com’, ‘cvides@proesa.gob.sv’, ‘gripper@nupro-products.com’, ‘sarah.holmes@ubs.com’, ‘mpark@wnwcapital.com’, ‘kscott@hbloom.com’, ‘daniel.low@hapbc.com.cn’, ‘rhorstman@hunter-keith.com’, ‘bkortrey@ri-llc888.com’, ‘info@shangrila-beer.com’, ‘egallagher@amnh.org’, ‘kim.bill@nestle.com’, ‘t.garti@lek.com’, ‘s.jackson@lek.com’, ‘nicholas.mcclintock@rbs.co.uk’, ‘ramirezc@iata.org’, ‘will.xie@merckgroup.com’,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center