Bob Webb asked 12 months ago
I'm struggling to create a view to display what I want but I can do it in MySQL. Is there a way to get Formidable to display the result from a query?
If not can someone give me a pointer on how to replicate the query (edited to be acceptable for entry) below with the view builder?
YEAR(`created_at`), WEEKOFYEAR(`created_at`), sum(`meta_value`) FROM `frm_item_metas`
where `item_id` in (my selection criteris)
and `field_id` = 52
Group by YEAR, WEEKOFYEAR
Thanks in advance.
Victor Font Staff answered 12 months ago
Yes. You can do this with the frm_view_order filter. It’s the only filter in Formidable where you can use a custom query with a view. The query needs to return a list of entry ids that meet the search criteria and the view will process the results accordingly. This is the topic of my next Developers Series book. I’ll be teaching how to open the entire RDBMS to Formidable.
Bob Webb
replied 11 months ago <p>Thanks Victor - for some reason I didn't get a notice about your response so please excuse my tardiness. I'll look into this and, almost inevitably, come back to you. Where can I get notice of your forth coming publication? _ </p><h1 class="entry-title">The Masterminds Store?</h1>
I publish announcements about book a column releases in my Formidable Masterminds Facebook Group. Please feel free to join. https://www.facebook.com/groups/formidablemasterminds
Also, when you use custom SQL or SQL views with frm_view_order, all you need to do is return a list of matching entry ids.
Please login or Register to submit your answer
