Re: Looking up arrays in a sub-entity

2015-05-20 Thread rumford
I was able to get what I wanted by processing the column in question as massaged text, so that it was a comma-delimited series of IDs, and then passing that to a subentity query that went something like: SELECT value FROM othertable WHERE id IN (${master.ids}). It's slow but I think it's getting t

Looking up arrays in a sub-entity

2015-05-19 Thread rumford
I have an entity which extracts records from a MySQL data source. One of the fields is meant to be a multi-value field, except, this data source does not store the values. Rather, it stores their ids in a single column as a pipe-delimited string. The values themselves are in a separate table, in an