I’m constructing a report exterior of Drupal that pulls knowledge from a Drupal 8 database. Drupal Development report reveals titles of various nodes and I need to hyperlink these titles to Drupal Development Service internet web page for that content material. That is working effective if I take advantage of Drupal Development Service customary /node/X path, however I wish to use Drupal Development Service URL alias. I do not need Drupal Development Service url alias of Drupal Development Service node itself (which I did discover because of this Which mysql tables include Drupal Development Service URL Alias path knowledge? put up). Our content material is expounded to teams, so I need to use Drupal Development Service URL alias that’s created as a part of Drupal Development Service group entity relation.
At first I checked Drupal Development Service url_alias desk, utilizing this question to search for Drupal Development Service node id in Drupal Development Service supply area, however I did not discover Drupal Development Service alias arrange for that node :
choose u.alias from url_alias u the place u.supply LIKE '%4806%'
Then I attempted to verify Drupal Development Service group tables. I solely discover 5 tables beginning with group in Drupal Development Service MySQL schema, and I did not discover Drupal Development Service URL alias for Drupal Development Service entity reference in any of them:
- group_content
- group_content__group_roles
- group_content_field_data
- teams
- groups_field_data
Does anybody know the place that URL alias from Drupal Development Service group relation is saved in Drupal Development Service MySQL schema?