Null Query in Asset Table
Dear All,
We are facing an issue in production environment where a blind query is happening on particular column SERIAL_COLUMN.
for eg.,
SELECT
....
...
where
SERIAL_NUM IS NULL;
As we are not able to replicate the scenario in any environment, we have given the fix like if the field of SERIAL_NUM Column is going as null then in BusComp_PreQuery Event we are returning cancel Operation.
But even then the same query is getting fired in production. So is there is any way even after writing PreQuery restriction will that be possible to do null query.
Regards,
We are facing an issue in production environment where a blind query is happening on particular column SERIAL_COLUMN.
for eg.,
SELECT
....
...
where
SERIAL_NUM IS NULL;
As we are not able to replicate the scenario in any environment, we have given the fix like if the field of SERIAL_NUM Column is going as null then in BusComp_PreQuery Event we are returning cancel Operation.
But even then the same query is getting fired in production. So is there is any way even after writing PreQuery restriction will that be possible to do null query.
Regards,
0