Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
delimited lists are used in queries all the time, they merely require processing unless they are stored with single quotes and commas in place already.Haryer wrote:The lead_id and user are what you can use to find the recordings for a specific call looking at the recording_log table.
There is no recording_id in the vicidial_agent_log table because there can be multiple recordings per call, and which one would you put in that field if it was in there? The first one, the last one, or some delimited list that could not be used in a direct query?
Users browsing this forum: No registered users and 55 guests