DataAssist Help Required: Filtering via two recordsets
I have a page that contains two recordsets (Recordset1 & Recordset2) which contain the information required to place a single wordpress post into that page.
Please forgive the complete lack of technical know-how. I can place dynamic text on the page OK, but I don't know how to filter it through two recordsets. It would not be a repeating region.
I want to place on the page:
• the most recent post (Recordset1: 'post_title', 'post_date', 'post_content')
• of a certain category (Recordset2: 'slug' value = 'site-item')
[If I order Recordset1 by 'post_date' Descending, I presume this will give me the latest post by just putting in the dynamic text as mentioned in the first bullet point above. Is this the correct way? If so, I just need to filter it based on the value in Recordset2.]
Please could someone baby-step me through the process?