Extract information from Identifiers (CG02)

[imachoshvili]

Hello everyone,

I have a list of substances created in CG02 and these substances have several lines in Identifiers tab, filled with diverse information.

Each line could or could not have USAGE information.

Is it possible to extract information from USAGE based on a list of substances? I need to check ValAreaCat and Validity Area as shown below in the red square.

Thanks.

Igor

[satya11719]

Hi Igor,

You need to build a query using SQVI between ESTRH for specification header and ESTRI for identifier and ESTDU for usage of identifier this will give you the list of identifier has usage

Best

Satya