Hi all!
I've been working on creating some links that are used in our support ticketing system that help make viewing data about customers easier. Essentially, my process has been to create a Question in metabase, copy the resulting query hash, decode it, and replace the filter with a placeholder variable. Then, when the URL is generated, it puts the appropriate filter in place and re-encodes the query. This works great.
What I'd like to do now is have a custom column in this Question that links to another question. Conceptually, this isn't hard. The second question filters based on an ID that is a column of the first question. In theory, I could de-encode the query hash, drop the column reference into the appropriate place in the query and then re-encode it again. However, I don't see any kind of functions to encode/decode. I also didn't see any way to accomplish this outside of the low-level method I'm describing.
Is there a way to accomplish this? Or is there another approach that's easier?
Regards,
-Joel
on the first post