Hi Readers,
I have a scenario where i need help to complete.
The scenario is i have 2 record types they are which are related as one to many relation
Below are the two table table: Table_A and Table_B which are related by CLuster_ID one to many relation ship
Table_A: Number of records in table_A are 4
Table_B: Number of records in table_B are 8
Here table_B is used as the final interface to view the data, hence i have used record link to get the summary view for both table on VM_name and Cluster_name
For VM_Name the summary view is working fine for all the records but for summary view for cluster_name in table_B its working fine for only 1st four rows and for the rest of the rows getting error as below snip.
and when opening link cluster-1 in table-2 1st column i am getting the summary view of cluster-1 -- This should be fine, but issue is with below once
and when opening link cluster-1 in table-2 2nd column i am getting the summary view of cluster-2
and when opening link cluster-2 in table-2 3rd column i am getting the summary view of cluster-3
and when opening link cluster-2 in table-2 4th column i am getting the summary view of cluster-4
and when opening link cluster-3 in table-2 5th column i am getting the summary view of cluster-5 -- Getting the error snip as above
what is expected is which ever link is pressed or opened the summary of that label need to shown
Generic code used for record link for cluster_column in table_B a!gridColumn( label: "Cluster_Name", sortField: 'recordType!ivVm.relationships.ivCluster.fields.Windows_Cluster_Name', value: a!linkField( links: { a!recordLink( label: fv!row['recordType!ivVm.relationships.ivCluster.fields.Windows_Cluster_Name'], recordType: 'recordType!IV Cluster', identifier: fv!identifier ) } ) ),
a!gridColumn( label: "Cluster_Name", sortField: 'recordType!ivVm.relationships.ivCluster.fields.Windows_Cluster_Name', value: a!linkField( links: { a!recordLink( label: fv!row['recordType!ivVm.relationships.ivCluster.fields.Windows_Cluster_Name'], recordType: 'recordType!IV Cluster', identifier: fv!identifier ) } ) ),
Would like to know what changes need to be done if anything need to be done at identifier
Discussion posts and replies are publicly visible
What is the primary key of your Table_B?
The fv!identifier that you are passing in the record link as a parameter, exceeds the number 4 which is the total count of your Table_A.
Primary key of table_B is VM_ID.
Would like to know how can we set the fv!identifier to match the other table count i mean how can we make this right ?
Try something like this as the value for identifier. You do not have to use fv!identifier.
fv!row['recordType!ivVm.relationships.ivCluster.fields.id'],
yeah this fv!row worked out, fv!identifier is taking the reference of child table ID
As Stefan mentioned, you have to pass the identifier of your first Record
In general, as a debugging method and If you don't know what a variable's value is, you can create a simple text field in your record or grid and you can just show there the value of the current fv!row or fv!item.