81 Posts
Seb
6 years ago
Topic

(Excuse me for the first post is not correct, can you remove it?)

Hi,

I have a search list with a user Jform field (jform_user).
The user see a list of his articles only. Today the field not working and the list displays all the articles.
Configuration art_created_by field:
Storage: Standard / Article / created_by
Button 2: Dynamic = variable - created_by (screen attached file)

Joomla 3.3.6
Seblod 3.4.3

Thank you for your help,
Seb

Get a VIP membership
81 Posts
Seb
6 years ago
0
Level 1

Screen :

4229 Posts
Kadministrator
6 years ago
3
Level 1

Hi,

do you actaully have this variable in the url? If yes, then it should work if live value is set to variable - created_by

81 Posts
Seb
6 years ago
2
Level 2

Hi,

Tanks for your reply, I did not change this configuration over the last year. It worked well, I don't understand.
I'm not sure if this variable is within the url. I thought that when the user was logged, this variable is in the url.

Could you tell me how to display only items of the user connected?

I not see "created_by" in debug mode, but the field is in search list :

Debug mode :

SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t1.state = 1 AND t1.access IN (1,1,2,3,4,5,6,7,8) AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2014-12-16 13:14:26' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2014-12-16 13:14:26' ) AND t0.storage_location = "joomla_article" AND t1.catid LIKE '%140%' GROUP BY t0.pk
ORDER BY t1.created ASC

0.012 seconds (0.012); 13.48 MB (13.477) - afterSearch [Cache=OFF] = 5 results.
0.088 seconds (0.076); 14.64 MB (1.160) - afterRender [Cache=OFF]

Thank you for your help.

Seb

4229 Posts
Kadministrator
6 years ago
1
Level 3

If you don't see it in url, it is not in url. 

But there is another way - use live value User -> id instead.

81 Posts
Seb
6 years ago
0
Level 4

YES it's OK!

Tank you very much Klas!

Get a Book for SEBLOD