Skip to main content
amaans4178
amaans4178
September 2, 2024
Solved

Record Relationships

  • September 2, 2024
  • 11 replies
  • 0 views

Hi everyone,

I'm seeking guidance on best practices for handling a specific scenario in Appian. Here’s the situation:

I have two records:

  • Record A, with a primary key column named A1.
  • Record B, with a primary key column named B1.

There is a one-to-many relationship from Record A to Record B. I'm retrieving data of Record B using the 'relationship/related record data' from Record A, in both interfaces and expression rules. I've also defined the reverse relationship in Record B as many-to-one from Record B to Record A using the same column.

However, when deploying, I encounter an issue with missing objects.

Could you advise on the best course of action or Appian best practices for managing this type of relationship? Is there a recommended approach to avoid such issues in the future, or is there an alternative method for defining relationships?

Thanks!

Best answer by vineshg3398

Your point is while deploying cross related record for the first time both the record will through missing precedents error because both records relate to each other in this case the best way is two remove all the relations and related objects in record (view and action) and deploy and again deploy the same with older version with every relation intact.

correct me if I am wrong or if there is another, would love to discuss on that!

11 replies

stefanhelzle0001
stefanhelzle0001
September 2, 2024
However, when deploying, I encounter an issue with missing objects.

Can you go into more detail here?

amaans4178
amaans4178Author
September 2, 2024

I'm asking about the relation, does appian restricts us to do what i explained above ? or getting data from such relation will result into any future problems 

stefanhelzle0001
stefanhelzle0001
September 2, 2024

Your use case is absolutely within the limits of Appian and there are no future issues to expect.

venkatrea696188
venkatrea696188
September 2, 2024

Need more details about these missing Objects (Those are mostly related to Actions that are defined on Record).Try Pushing all of the Related actions (PM), Interfaces  and any Folders that are included ,within the same package 

amaans4178
amaans4178Author
September 2, 2024

yes i agree, but I'm asking about the relation, does appian restricts us to do what i explained above ? or getting data from such relation will result into any future problems 

venkatrea696188
venkatrea696188
September 2, 2024
or getting data from such relation will result into any future problems 

AFAIK , it will not cause any issue for you and there is no restriction.

    V
    vineshg3398Answer
    September 2, 2024

    Your point is while deploying cross related record for the first time both the record will through missing precedents error because both records relate to each other in this case the best way is two remove all the relations and related objects in record (view and action) and deploy and again deploy the same with older version with every relation intact.

    correct me if I am wrong or if there is another, would love to discuss on that!

      Terms & ConditionsAccessibility statement