• State Suggested Answer
  • +2 person also asked this people also asked this
  • Replies 13 replies
  • Answers 1 answer
  • Subscribers 11 subscribers
  • Views 12340 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

Joining two or more tables at Interface level

digantas

Is it possible to combine two tables at interface level without using a view?Can we fetch the data with rules and join them thereafter?

Thanks is advance.

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Associate Developer
    Hi Digant,

    Below logic will help you.
    Let say you have two CDT's having containing below fields
    CDT1:{eid,ename,designation}
    CDT2:{eid,salary,age}
    Where eid is the common value in both the CDT's. Now as per your requirement you can do this

    CDT3:index(
    CDT1,
    wherecontains(
    cast(101,CDT2.eid),
    cast(101,CDT1.eid)
    ),
    {}
    )

    This will return you the matching values from CDT1, Incase if you need data from CDT2 then just replace CDT1 and CDT2 with each other in the above example. Hope this will work for you
Reply
  • 0
    Certified Associate Developer
    Hi Digant,

    Below logic will help you.
    Let say you have two CDT's having containing below fields
    CDT1:{eid,ename,designation}
    CDT2:{eid,salary,age}
    Where eid is the common value in both the CDT's. Now as per your requirement you can do this

    CDT3:index(
    CDT1,
    wherecontains(
    cast(101,CDT2.eid),
    cast(101,CDT1.eid)
    ),
    {}
    )

    This will return you the matching values from CDT1, Incase if you need data from CDT2 then just replace CDT1 and CDT2 with each other in the above example. Hope this will work for you
Children
No Data

© 2024 Appian. All rights reserved.