If field type is choice list then validate the data as well with whatever data we have stored against the valid values of this drop-down.

[suresh kumar6]

If field type is choice list then validate the data as well with whatever data we have stored against the valid values of this drop-down. 

For example : through script if you set the value to the choice list filed ,then value will visible in the record ,but that choice is not created in the database ,so that is invalid data,we need to find out that invalid data and also we need to find out no of records with invalid data.

[Manish Vinayak1]

You could create a report on that table and apply a filter which says,

"Field Value" "IS NOT ONE OF" "All available options selected".

Example: I have set an invalid value in Category field to one of the incident records; and I have applied the following filter to see all the records having invalid category values:

I have selected all the available options present for Category fields with the operator "is not one of". Which shows me the records with invalid values:

[suresh kumar6]

Can you provide the script for this?

I have written code for this already ,but its not working ,so if it possible provide the script for this task.