최근 검색
최근 검색 없음

Matt Claycomb
가입한 날짜: 2021년 10월 16일
·
마지막 활동: 2021년 10월 16일
팔로잉
0
팔로워
0
총 활동 수
3
투표 수
0
가입 플랜
1
활동 개요
배지
문서
게시물
커뮤니티 댓글
문서 댓글
활동 개요
님의 최근 활동 Matt Claycomb
Matt Claycomb님이 에 댓글을 입력함
Jason,
I am not sure I follow. I know in an SQL database, I would have to use an intermediary table. Take the following example, if I want a many-to-many relationship between the Zendesk type ticket and a custom object named "location", I would have to do the following:
- Create the custom object type "location".
- Create a custom object type "location_ticket".
- Create a many-to-one relationship type from "location" to "location_ticket" named "location-has-many-location_ticket".
- Create a one-to-many relationship type from "location_ticket" to "location" named "location_ticket-belongs-to-location".
- Create a many-to-one relationship type from "zen:ticket" to "location_ticket" named "zen:ticket-has-many-location_ticket".
- Create a one-to-many relationship type from "location_ticket" to "zen:ticket" named "location_ticket-belongs-to-zen:ticket"
Then any time I want to associate a ticket to a location or an additional location, I would need to do the following:
- Create an object of type "location_ticket".
- Create a relationship of type "location-has-many-location_ticket" between the "location" and the "location_ticket".
- Create a relationship of type "location_ticket-belongs-to-location" the other direction between the "location" and the "location_ticket".
- Create a relationship of type "zen:ticket-has-many-location_ticket" between the ticket and the "location_ticket".
- Create a relationship of type "location_ticket-belongs-to-zen:ticket" the other direction between the ticket and the "location_ticket".
Can you let me know if I'm on the right track, or completely off base?
Thanks,
Matt
댓글 보기 · 2021년 3월 26일에 게시됨 · Matt Claycomb
0
팔로워
0
투표 수
0
댓글
Matt Claycomb님이 에 댓글을 입력함
Hello,
In this article, it is specified that a many-to-many relationship is possible, however I am not finding how. If I attempt to submit a request to the API to create a relation which I believe would handle that (source and target are arrays), I get returned an error saying "Cannot create a relationship type where both source and target are arrays".
Also, is there a feature request page for having Custom Resources loaded into Insights? That function could greatly benefit our company as well.
Thank you,
댓글 보기 · 2021년 3월 26일에 게시됨 · Matt Claycomb
0
팔로워
0
투표 수
0
댓글