What are the maximum no.of conditions(Filters) can be specified in Report?

[swathi52]

Hello Everyone,

I am trying to create a report.

while adding Filters,It is not allowing me after certain conditions.Is there any constraint over it?

I tried to save report & run and save report..it is not working.

Thanks

swathi

[HarshTimes]

Hi Swathi

I am surprised to read that you have put 40 condition and you want to add more. I think you need to  look into you conditions and find some other alternative conditions. 40 conditions will make your report form load very slow. If you can provide the details I can help to build new conditons

Thanks

Harsh

[swathi52]

Hi Harsh,

Yes, i need to give that no. of conditions.

am not sure to share the conditions here.

am trying to get no of unassigned incidents, where depending on the whether user is in ownership of Ci/ Assignment group.

So here i am checking for 9 levels of owners for CI and as well as Assignment group.

Where i got a condition i need to repeat all this.

Thanks

swathi

[The SN Nerd]

Reports are records in ServiceNow, just like any other record.
The Filter is stored in a field called 'Filter', which has a max_length of 4000 and is stored as an encoded query (a string).
If you are approaching this limit in a report, you should probably consider doing some database rationalisation, using Database Views or an external tool.

[swathi52]

Hi Paul,

Thank you.

Is there any way i can check length of field? I just want to be sure that it is failing because of exceeding max_length.

Regrads,

Swathi

[The SN Nerd]

You can navigate to sys_dictionary.list and filter on table sys_report, adding the length field to the list.

That probably won't be the problem thought, ServiceNow will automatically truncate the field - it won't prevent the report from saving.