[SOLVED] Query filed question

Hertak
OFFLINE
Posts: 386
Thanks: 84
Karma: 29

11 years 4 months ago - 11 years 4 months ago #229265 by Hertak

[SOLVED] Query filed question was created by Hertak

Hi, the user nikomed ask a question on the spanish forum I try to help but i do not know the answer the question is the following

i add new rules with field y tab, using the Queries field.

The querie is:

SELECT: id
FROM: #__zcalendar_rsvps
WHERE: user = [id_user]

Until now every works fine, but i need use that the result of the query.

My idea with the ids (every id is a new page), show a link, every link change depended of the id .

www.miweb.es/id1
www.miweb.es/id2

Where idx, will be the id is the result of the query.

Thanks!

This is possible? Thanks.

Last edit: 11 years 4 months ago by krileon.

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

krileon
ONLINE
Posts: 48464
Thanks: 8280
Karma: 1443

11 years 4 months ago #229276 by krileon

Replied by krileon on topic Query filed question

Yes, just substitute in the query field as part of a delimiter field to have formatted output. Example as follows.

Code:

<a href="http://www.example.com/[cb_queryfield]">http://www.example.com/[cb_queryfield]</a>

The alternative is to modify the select query and do a CONCAT in the select to have the URL part added directly to the result.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

The following user(s) said Thank You: Hertak

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

Hertak
OFFLINE
Posts: 386
Thanks: 84
Karma: 29

11 years 4 months ago #229282 by Hertak

Replied by Hertak on topic Query filed question

Thanks kyle, i add your response here www.joomlapolis.com/forum/167-spanish/221607-crear-nueva-pestana--necesario-consulta-personalizada-icomo?start=12#229281

The following user(s) said Thank You: krileon

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

Hertak
OFFLINE
Posts: 386
Thanks: 84
Karma: 29

11 years 4 months ago #229289 by Hertak

Replied by Hertak on topic Query filed question

Thanks Kyle, solved

The following user(s) said Thank You: krileon

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

Moderators: beat, nant, krileon