get subsidiary from selecting from entity table

AI generated answer (using internal Slack threads):

To get the subsidiary from selecting from the entity table, you need to join the entity table with the subsidiary table. Here is an example of how you can do this:

sql
SELECT 
Entity.name AS "entity_name",
BUILTIN.DF(EntitySubsidiaryRelationship.subsidiary) AS "entity_subsidiary"
FROM Entity
LEFT JOIN EntitySubsidiaryRelationship ON Entity.id = EntitySubsidiaryRelationship.entity

In this query,

EntitySubsidiaryRelationship

is the table that holds the relationship between the entity and the subsidiary. The

BUILTIN.DF

function is used to get the subsidiary id from the

EntitySubsidiaryRelationship

table. For the case of a kititem, you can use the

kititemsubsidiarymap

table to get the subsidiaries. Here is an example:

sql
select * from item JOIN kititemsubsidiarymap ON item.id=kititemsubsidiarymap.item WHERE ...

In this query,

kititemsubsidiarymap

is the table that holds the relationship between the kititem and the subsidiaries. The

item.id

is joined with

kititemsubsidiarymap.item

to get the subsidiaries of the kititem. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******