Warning: Invalid query detected on checking Logs

[ssoniy]

After we enabled the property 'glide.invalid_query.returns_no_rows' , some of the Rest API queries not working.

System Logs looks like as shown below

Warning - QueryEventLogger

Invalid query detected, please check logs for details[Unknown field source_table in table change_request]

When we takeout 'source_table' parameter from the query it works fine. Can anyone please explain why this “source_table“ field is invalid in the query?

[Willem · Accepted solution]

Where is the Query done?

The error says why it is generated. the Field source_table does not exist in the Change Request table.

Here the fields in the table ordered alphabetically, not showing source_table:

[ssoniy]

Thanks fro the reply William. Yes we use that endpoint point through postman. If we remove only that field it works fine.

[Willem]

So is it working now? If so, please mark my answer as Correct to close the thread.

If not, can you share your postman API call?