
Anonymous Community User asked a question.
Making a More Complicated Filtered View
I have a CRM app that tracks customers' progress in a sales pipeline (e.g., research, interested, objections, signed). Every time the salesperson changes the pipeline status, a log entry is created in a separate app using GlobiFlow. This log app needs a view that shows the pipeline stages a particular customer has passed through, based on if they are in a particular pipeline status currently. For example, today CustomerX was updated to have a pipeline status of Signed. But, if I filter my Podio view by date I will only see the Signed log entry--not the previous log entries when the customer was in Research, Interested, etc. I need the view to show the Signed log entry *and* the log entries previous to that entry. In a typical RDBMS, I would create a query something like this: select O.customer, O.LogDate, O.Status from StatusLog O where O.customer in ( select I.customer from StatusLog I where I.LogDate = TODAY() and O.Status = 'Signed') To those wise in the ways of Podio, thanks in advance!