article title + icon in select field

More
6 years 8 months ago #72733 by aminweb
thanks for guide me.
but this syntax for statick item url.
I have many article items in category .
I want when select which one article title. dynimical linked to article.
I create a select field for hotel name. and use sql query for load article title in hotel category(id=10) :

SELECT DISTINCT id as value, title as text
FROM #__content AS i
JOIN #__flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id AND rel.catid= 10
WHERE i.state IN (1, -5)

now I want when select each title , linked to article

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

More
6 years 8 months ago #72734 by micker
please read more ...
the id is dynamic if you create a multivalue field you can read many link

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]
The following user(s) said Thank You: aminweb

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

More
6 years 8 months ago - 6 years 8 months ago #72735 by aminweb
thnaks.
but I did not get it.
please see screen my field
pasteboard.co/HfbcH8x.jpg
Last edit: 6 years 8 months ago by aminweb.

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

More
6 years 8 months ago #72736 by aminweb
I use sql query and query only titles article.
SELECT DISTINCT id as value, title as text
FROM #__content AS i
JOIN #__flexicontent_cats_item_relations AS rel
ON rel.itemid = i.id AND rel.catid= 10
WHERE i.state IN (1, -5)
not query ID of articles.
please help me.

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

More
6 years 8 months ago #72737 by micker
sorry i don't understand ..... you can't create 1 link to X item in same ahref
maybe you can use multiselect field

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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

More
6 years 8 months ago #72738 by micker
sorry in don't understand what you whant to do .....
exmplain more the goal the context ...
1 what you want to display
2 what is tour field configuration
...

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]
The following user(s) said Thank You: aminweb

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 1.527 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline