Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Sunday 3:25 am
Add a reply View Replies (2)

Resolved Custom SQL shortcodes

  1. morgan_leecy
    morgan_leecy
  2. Support
  3. Monday, September 12 2016, 03:44 PM
If I have asked this before, I apologise.. getting my components mixed up

I want to do a menu item with a custom SQL

That statement is 'WHERE my_record = (ID of signed in user)' i.e jFactory::getUser()->id

I looked in the docs but cant find a short code such as [ID]
  1. custom sql
Responses (2)
admin
admin Accepted Answer
Admin
Hi,
Our Content Plugin works also in SQL Custom Where, so you can use some code like this:


my_record='{user id raw}'

NOTE: remove "WHERE"

Docs about Content Plugin at http://docs.easy-profile.com/index.php/article/content-plugin
  1. more than a month ago
  2. Support
  3. # 1
morgan_leecy
morgan_leecy Accepted Answer
Pro
Beautiful! Works perfectly
  1. more than a month ago
  2. Support
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.