How To Find All Invalid Mappings In A Folder?

1.	How To Find All Invalid Mappings In A Folder?
Answer» USE FOLLOWING query SELECT MAPPING_NAME FROM REP_ALL_MAPPINGS WHERE SUBJECT_AREA='YOUR_FOLDER_NAME' AND PARENT_MAPPING_IS_VALIED &LT;&GT;1 Use following query SELECT MAPPING_NAME FROM REP_ALL_MAPPINGS WHERE SUBJECT_AREA='YOUR_FOLDER_NAME' AND PARENT_MAPPING_IS_VALIED <>1

Answer»

SELECT MAPPING_NAME FROM REP_ALL_MAPPINGS WHERE

SUBJECT_AREA='YOUR_FOLDER_NAME' AND PARENT_MAPPING_IS_VALIED &LT;&GT;1

Use following query

SELECT MAPPING_NAME FROM REP_ALL_MAPPINGS WHERE

SUBJECT_AREA='YOUR_FOLDER_NAME' AND PARENT_MAPPING_IS_VALIED <>1

Discussion