Any easy way to do this if they don't have a parti...
# administrationd
Dakotah_NSC
06/25/2020, 11:53 PMAny easy way to do this if they don't have a particular flag or univeral criteria to use?
d
Dakotah_NSC
06/25/2020, 11:56 PMThanks. Scripting isn't really an option in this case, nor would be mass updating a flag or anything.. our controls are extremely tight on production changes and approvals would take a long time and explanation
b
battk
06/25/2020, 11:56 PMread the whole thread
d
Dakotah_NSC
06/25/2020, 11:58 PMSure, are you saying to plug all 800+ customers into a SQL formula?
Dakotah_NSC
06/25/2020, 11:58 PMNo stranger to SQL in searches, but wasn't really thinking that large of a formula would work
b
battk
06/25/2020, 11:59 PMthe in operator goes upto 1000
battk
06/25/2020, 11:59 PMwhich should work fine for you
battk
06/25/2020, 11:59 PMdont expect performance to be great
d
Dakotah_NSC
06/26/2020, 12:00 AMWow. That's impressive. Performance doesn't matter so much, it's a one time query I need. Thanks a bunch. I'll give it a try
Dakotah_NSC
06/26/2020, 12:51 AM@battk Strung together a few extremely large formulas with or statements... worked like a charm. Funny how the obvious solutions aren't always the ones we think to try first. Thanks!
5 Views