query

this error am getting how can i fix this

am querying this data to display in grid, is their any other way to display the data ?

  Discussion posts and replies are publicly visible

Parents
  • If that query is intended to be run while one or more of the filtering options have a value (which we can see are loaded as blank initially), you should probably prevent the query from executing at all until at least one of the filters is given a value, since (per your error message) the non-filtered query is returning enough data to trip the mandatory 1-megabyte query circuit breaker.  Either that or initially run the query with a "real" batch size (instead of the "all rows" batch size of -1).

Reply
  • If that query is intended to be run while one or more of the filtering options have a value (which we can see are loaded as blank initially), you should probably prevent the query from executing at all until at least one of the filters is given a value, since (per your error message) the non-filtered query is returning enough data to trip the mandatory 1-megabyte query circuit breaker.  Either that or initially run the query with a "real" batch size (instead of the "all rows" batch size of -1).

Children
No Data