Identify all answers and Liveboards that depend on a specific Worksheet

[r-q82]

Hi,

Is there any possibility of using cs_tools to identify all answers and Liveboards that depend on a specific Worksheet?

Thanks
RQ

[boonhapus]

You can run Searchable gather to find all of the information across the platform. If you use a SQLite syncer, then you're able to write a query to get this information.

SELECT
    d.*

FROM
  ts_metadata_object AS o

JOIN
  ts_metadata_column AS c ON c.object_guid = o.object_guid

JOIN
  ts_metadata_dependent as d ON d.column_id = c.column_id

WHERE
    o.metadata_subtype = 'WORKSHEET'

    -- change to the parent worksheet!
    AND o.name = 'my worksheet name'

[r-q82]

Thank you very much. It was very helpful.

Regards,
RQ