cb query field

hallo there,

i want help with something i cannot figure out.
i write a query but i miss one parameter which i don`t know how to express it. i want to retrieve the last k2 item a user has published.
there was a plugin for cb 1.9.1 from a 3rd party developer where in created_by has the value {USERID} and with this way, it recognized the user who has published it, i had my results..

what should i have in the ???? in order cb query to recognize the user??

thank you very much!!!

extensions.joomla.org/extensions/extension-specific/community-builder-extensions/community-builder-profiles/10043

CB Query Field support standard substitutions as documented below.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb

So for example if you need the user id you can use [user_id].

awesome!!!
thank you very much!and something else if it is possible..the result of my query is a k2 item..is there any way to link it with the k2 item page?Like the CB 2.0 articles do..

thank you again!

You'd have to build the URL manually in your query results display then substitute in the needed information for the URL, which for K2 is the article id and alias. So you'd need to set it to multiple column output with custom display. You can then substitute in column values using [column_COLUMN_NAME] (e.g. [column_title]).

sorry kyle,

but i lost you totally..

this is my query
in the parameters i have output "single row" and "multiple columns". as i have see in the table #k2_items there is not the url of the k2 item to retrieve it.

for now my result is

i want by clicking "the_k2_item" to redirect to the page of the k2 item

thank you

You need the below usage to have multi-column display.

Output: Single Row
Columns: Multiple Columns
Display: Custom
Custom:
The columns in your SELECT can be substituted in using [column_COLUMN_NAME]. This information is also detailed in the tooltips of the various parameters.

The URL does exist in the database. You need to format the URL using database information. Specifically the "id" and the "alias" are used in the URL. To get the URL structure navigate to a K2 article without SEF and begin with index.php. Example as follows.

index.php?option=com_k2&view=item&id=[column_id]:[column_alias]