I wonder whether how to create a calculated field and unwrap an array column. My main purpose is to be able to filter according this new unwrapped column. For instance, I have an array for each row containing info on store types:
<code>id 1 = [demand, asap],
id 2 = [asap],
id 3 = [demand, asap, delayed],
id 4 = [];
</code>
<code>id 1 = [demand, asap],
id 2 = [asap],
id 3 = [demand, asap, delayed],
id 4 = [];
</code>
id 1 = [demand, asap],
id 2 = [asap],
id 3 = [demand, asap, delayed],
id 4 = [];
and I want to receive an unwrapped version:
<code>id 1 = demand
id 1 = asap
id 2 = asap
id 3 = demand
id 3 = asap
id 3 = delayed
id 4 = Null
</code>
<code>id 1 = demand
id 1 = asap
id 2 = asap
id 3 = demand
id 3 = asap
id 3 = delayed
id 4 = Null
</code>
id 1 = demand
id 1 = asap
id 2 = asap
id 3 = demand
id 3 = asap
id 3 = delayed
id 4 = Null
Should I do it with custom SQL? If I should, how do I do it?