ExpressionEngine 查询模块 - 仅从特定类别检索相关条目
我的 SQL 知识已达到极限。我将相关条目拉入 Safecracker 表单中，作为下拉输入，并且希望从数据库中仅检索特定类别的相关条目。例如，我有一个“事件”频道，您可以在其中将事件与“位置”频道中的条目相关联。我不需要查看所有可能的场地，只需查看与特定类型的活动相关的特定类别的场地即可。有人有什么想法吗？预先感谢您的帮助。
我忘了提及，我已经有查询提取出所有相关条目，但到目前为止还没有按类别进行过滤。
<label>RELATED ENTRY TEST</label>
<select name="event_rel_location" id="event_rel_location">
<option value="">--</option>
{exp:query sql="SELECT entry_id AS rel_entry_id, title AS rel_title, (SELECT rel_child_id FROM exp_relationships WHERE rel_id = '{event_rel_location}' LIMIT 10) AS rel_child_id FROM exp_channel_titles WHERE channel_id = 51 AND status='Open' ORDER BY title ASC "}
<option value="{rel_entry_id}" {if rel_child_id == rel_entry_id} selected="selected"{/if}>{rel_title}</option>
{/exp:query}
</select>
I'm running into the limits of my SQL knowledge. I'm pulling related entries into a Safecracker form, as pull-down inputs, and want to retrieve only related entries of a particular category from the database. For example, I've got an 'events' channel, in which you can relate the event to an entry in a 'locations' channel. I don't need to see all of the possible venues, just ones from a particular category that relate to a particular type of event. Anyone have any ideas? Thanks in advance for your help.
I forgot to mention that I already have the query pulling out ALL of my related entries, but so far no luck filtering by category.
<label>RELATED ENTRY TEST</label>
<select name="event_rel_location" id="event_rel_location">
<option value="">--</option>
{exp:query sql="SELECT entry_id AS rel_entry_id, title AS rel_title, (SELECT rel_child_id FROM exp_relationships WHERE rel_id = '{event_rel_location}' LIMIT 10) AS rel_child_id FROM exp_channel_titles WHERE channel_id = 51 AND status='Open' ORDER BY title ASC "}
<option value="{rel_entry_id}" {if rel_child_id == rel_entry_id} selected="selected"{/if}>{rel_title}</option>
{/exp:query}
</select>
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
是的，这将是一个棘手的问题...可能是更好地利用您的时间/预算来购买 Playa ，将您的关系字段转换为 Playa，然后使用 Playa 模块标签，它允许您按类别限制相关和反向相关条目（
{exp:playa:parents}和{exp:playa:children}）。Yup, that'll be a tough query ... might be a better use of your time/budget to buy Playa, convert your relationship field to Playa, then use the Playa module tags instead, which allow you to restrict related and reverse-related entries by category (
{exp:playa:parents}and{exp:playa:children}).