/build/static/layout/Breadcrumb_cap_w.png

Is there a limit to the number of rules I can use in a SQL report

I wrote a SQL report to list all the machines that do not match our department naming rules.  It runs but it only filters on the first 20 items, I have 64 in the list.

SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, LAST_SYNC
FROM MACHINE
WHERE
    (SYSTEM_DESCRIPTION NOT LIKE '%Adult_Basic_Education%'
or SYSTEM_DESCRIPTION NOT LIKE '%Academic_Affairs_and_Student_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Academic_Support_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Accounting_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Admissions_and_Records%'
or SYSTEM_DESCRIPTION NOT LIKE '%Advisement_and_Transfer_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Biology%'
or SYSTEM_DESCRIPTION NOT LIKE '%Budget_and_Planning%'
or SYSTEM_DESCRIPTION NOT LIKE '%Child_Care_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Computer_Technologies%'
or SYSTEM_DESCRIPTION NOT LIKE '%Counseling%'
or SYSTEM_DESCRIPTION NOT LIKE '%Culinary_Arts%'
or SYSTEM_DESCRIPTION NOT LIKE '%Dental_Assisting%'
or SYSTEM_DESCRIPTION NOT LIKE '%Dental_Hygiene%'
or SYSTEM_DESCRIPTION NOT LIKE '%Disability_Resource_Cente%'
or SYSTEM_DESCRIPTION NOT LIKE '%Division_of_Applied_Industrial_Technology%'
or SYSTEM_DESCRIPTION NOT LIKE '%Division_of_Business%'
or SYSTEM_DESCRIPTION NOT LIKE '%Division_of_Liberal_Arts%'
or SYSTEM_DESCRIPTION NOT LIKE '%Division_of_Sciences%'
or SYSTEM_DESCRIPTION NOT LIKE '%Division_of_Web_College%'
or SYSTEM_DESCRIPTION NOT LIKE '%EMS-Paramedic%'
or SYSTEM_DESCRIPTION NOT LIKE '%English%'
or SYSTEM_DESCRIPTION NOT LIKE '%Equity_and_Inclusion%'
or SYSTEM_DESCRIPTION NOT LIKE '%Facility_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Faculty_Senate%'
or SYSTEM_DESCRIPTION NOT LIKE '%Finance_and_Administrative_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Financial_Aid%'
or SYSTEM_DESCRIPTION NOT LIKE '%Financial_Aid_and_Student_Success%'
or SYSTEM_DESCRIPTION NOT LIKE '%Fire_Science%'
or SYSTEM_DESCRIPTION NOT LIKE '%History_Political_Science_and_Law%'
or SYSTEM_DESCRIPTION NOT LIKE '%Human_Resources%'
or SYSTEM_DESCRIPTION NOT LIKE '%Humanities%'
or SYSTEM_DESCRIPTION NOT LIKE '%Information_Technology_Operations%'
or SYSTEM_DESCRIPTION NOT LIKE '%Information_Technology_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Institutional_Advancement_/_Foundation%'
or SYSTEM_DESCRIPTION NOT LIKE '%Institutional_Research%'
or SYSTEM_DESCRIPTION NOT LIKE '%Instructional_Support%'
or SYSTEM_DESCRIPTION NOT LIKE '%Liberal_Arts%'
or SYSTEM_DESCRIPTION NOT LIKE '%Library%'
or SYSTEM_DESCRIPTION NOT LIKE '%Mathematics%'
or SYSTEM_DESCRIPTION NOT LIKE '%New_Student_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Nutrition%'
or SYSTEM_DESCRIPTION NOT LIKE '%Nursing%'
or SYSTEM_DESCRIPTION NOT LIKE '%Outreach_and_Recruitment%'
or SYSTEM_DESCRIPTION NOT LIKE '%Physical_Sciences%'
or SYSTEM_DESCRIPTION NOT LIKE '%President%'
or SYSTEM_DESCRIPTION NOT LIKE '%Professional_Development%'
or SYSTEM_DESCRIPTION NOT LIKE '%Police_and_Public_Safety%'
or SYSTEM_DESCRIPTION NOT LIKE '%Radiologic_Technology%'
or SYSTEM_DESCRIPTION NOT LIKE '%Redfield_High_Tech_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Re-Entry/Job_Prep/Career%'
or SYSTEM_DESCRIPTION NOT LIKE '%Retention_Support_Programs%'
or SYSTEM_DESCRIPTION NOT LIKE '%Scheduling%'
or SYSTEM_DESCRIPTION NOT LIKE '%Skills_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Social_Sciences%'
or SYSTEM_DESCRIPTION NOT LIKE '%Student_Outreach%'
or SYSTEM_DESCRIPTION NOT LIKE '%Student_Activities_and_Leadership%'
or SYSTEM_DESCRIPTION NOT LIKE '%Student_Services%'
or SYSTEM_DESCRIPTION NOT LIKE '%Tutoring_and_Learning_Center%'
or SYSTEM_DESCRIPTION NOT LIKE '%Veterans_Upward_Bound%'
or SYSTEM_DESCRIPTION NOT LIKE '%Veterinary_Technology%'
or SYSTEM_DESCRIPTION NOT LIKE '%Visual_and_Performing_Arts%'
or SYSTEM_DESCRIPTION NOT LIKE '%WDCE%')
 ORDER BY SYSTEM_DESCRIPTION asc,MACHINE.NAME asc


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
changed the or's to and's
Posted by: nshah 12 years ago
Red Belt
0

I haven't heard of one before. This might be a question for support to double check for you. 

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ