Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. 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: Wednesday 5:04 am
Add a reply View Replies (3)

Resolved SQL request in custom field

  1. magali-madec
    magali-madec
  2. Features Request
  3. Tuesday, March 22 2022, 07:48 PM
I need to create a hidden field with the result of a SQL request.
I have create a field type "select" but only WHERE argument is avalaible in SQL field in tab "Options Select Fields"

Which field is it possible to create to get a request which one use the id of the register user as :

SELECT MyIdField
FROM table_jsn_users
WHERE id={user->Myid}
Attachments (2)
Capture d’écran 2022-03-22 à 19.42.33.png Capture d’écran 2022-03-22 à 19.42.33.png
Capture d’écran 2022-03-22 à 19.43.24.png Capture d’écran 2022-03-22 à 19.43.24.png
  1. custom field
  2. Field type
  3. custom sql
  4. field parameters
  5. Register
Responses (3)
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply, this parameter support our content plugin, so you can use a syntax like 
id = {user id displayed raw}


Docs about content plugin at http://docs.easy-profile.com/index.php/article/content-plugin
  1. more than a month ago
  2. Features Request
  3. # 1
cristianbravo
cristianbravo Accepted Answer
Pro
I also need to get this accomplish. I need to show the user ID in when i pull up user list. how can i get this done. please help
  1. more than a month ago
  2. Features Request
  3. # 2
admin
admin Accepted Answer
Admin
Hi @Alpha,
what you need is something different than the request in this topic. Reply to your question at https://www.easy-profile.com/support/include-user-id-in-the-users-list-display.html
  1. more than a month ago
  2. Features Request
  3. # 3
  • Page :
  • 1


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