× This is the optional Forum header for the Suggestion Box.

Pre-Purchase Q: Display data by giving User ID(s)

Start
Prev
1
Next
End

andybon
Topic Author
Offline
New Member

11 years 2 months ago #2411

Hi - Looking with interest at Table JX

I see it can pull data unique to the logged in user which is great... can it also pull data based on one, or a list of, user IDs as well?

Reason I am interested in this - I run a sports results site and there's many scenarios where my users want to see the results of a certain user, or sometimes multiple users... so can I say for example, create a Table JX view that would look at a database table and extract say data relating to User IDs 56, 78 and 123 (which I'd specify at the back-end menu creation perhaps)?

Thanks!

Please Log in or Create an account to join the conversation.

tomaz
Offline
Administrator

11 years 2 months ago #2412

Hi,

Positive. You can specify an "Additional Where Condition" at creating a Table JX view. There you can set any kind of SQL where condition, e.g. if you want to display data related to users wit ids 56, 78 and 123 and your user id field is named "userid" you will just write

userid IN(56, 78, 123)

in the Additional Where Condition text box

The following user(s) said Thank You: andybon

Please Log in or Create an account to join the conversation.

andybon
Topic Author
Offline
New Member

11 years 2 months ago #2414

That's great news! Thanks :-)

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Pre-Purchase Q: Display data by giving User ID(s)

Contact Us

Contact us on Discord

Contact us on Facebook