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

[christoph_bergemann]

Hello

the option presented by Satya can only be used if there is no "inheritance" used in the system. If you are using "inheritance".. then the proposal will provide not the full data (but most of the data as needed),

The "SQVI" option is the "quick" solution. If the analysis should not be done in the future by a "technical" oriented person: you can think about to prepare an "output variant" so that based on "hit list" you can extract the identfier and the usage (and then you could include the "inheritance" part as well).

If you need as well the list of "assigned" reglatory lists (per identifier): you can easily extend the SQVI query and you will get the result (same if you would like to use the "outputvariant" option.)

So if this is a "one any only" analysis... SQVI is a very helpful option

C.B.

[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

[holger_hartung]

Hi,

you could join table ESTRH and ESTRI to extract information.