public java.lang.String getFK(java.lang.String pPropertyName)
This method returns information relative to the foreign key (or join or reference) of a datastore during a check procedure. It is accessible from a Knowledge Module only if the current task is tagged as a "reference".
In an action, this method returns information related to the foreign key currently handled by the DDL command.
Parameter |
Type |
Description |
---|---|---|
pPropertyName |
String |
String containing the name of the requested property. |
The following table lists the different possible values for pPropertyName
Parameter value |
Description |
---|---|
ID |
Internal number of the reference constraint. |
FK_NAME |
Name of the reference constraint. |
FK_TYPE |
Type of the reference constraint. |
FK_ALIAS |
Alias of the reference table (only used in case of a complex expression) |
PK_ALIAS |
Alias of the referenced table (only used in case of a complex expression) |
ID_TABLE_PK |
Internal number of the referenced table. |
PK_I_MOD |
Number of the referenced model. |
PK_CATALOG |
Catalog of the referenced table. |
PK_SCHEMA |
Physical schema of the referenced table. |
PK_TABLE_NAME |
Name of the referenced table. |
COMPLEX_SQL |
Complex SQL statement of the join clause (if appropriate). |
MESS |
Error message of the reference constraint |
FULL_NAME |
Full name of the foreign key generated with the local object mask. |
<flexfield code> |
Flexfield value for this reference. |
The current reference key of my table is called: <%=odiRef.getFK("FK_NAME")%>. It references the table <%=odiRef.getFK("PK_TABLE_NAME")%> that is in the schema <%=odiRef.getFK("PK_SCHEMA")%>