Open menu

Help simple query

igcorreia
Topic Author
Offline
Platinum Member

11 years 9 months ago #39645 by igcorreia

Help simple query was created by igcorreia

Hello, can anyone help me with one query:

I want to get all active items in flexi content from a category.

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

ggppdk
Offline
Administrator

11 years 9 months ago #39657 by ggppdk

Replied by ggppdk on topic Help simple query

Hello,

this sound like the query we have in our content lists, e.g. category view,

which uses
Access level of item,
Access level of main category,
... and Access level of item's content type

and takes into account
- publishing state of items
- publish-up and publish down dates of items

is that what you mean ?

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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

igcorreia
Topic Author
Offline
Platinum Member

11 years 9 months ago #39662 by igcorreia

Replied by igcorreia on topic Help simple query

I am actually trying something very difficult for me.

I was trying to make a FRONT END VERSIONS VIEW where I can know in the front end what the clients are doing.

I was thinking on adapt the category view but it is 2 expensive.

Do you think is easy to make this?

This is as var as I a went and took me all day

Code:

SELECT  `j25_flexicontent_items_versions`.`version`  as version,
		                `j25_flexicontent_versions`.`created`        as created,
                              /*`j25_flexicontent_versions`.`created_by`     as author,*/
		                `j25_users`.`name`                           as name,
		                `j25_flexicontent_items_versions`.`value`    as valuechanged,
		                `j25_flexicontent_fields`.`label` as fieldlabel,
		                `j25_users`.`name`                           as name
				FROM  `j25_flexicontent_items_versions` 
				INNER JOIN  `j25_flexicontent_versions` ON  `j25_flexicontent_items_versions`.`version` =  `j25_flexicontent_versions`.`version_id` 
				INNER JOIN  `j25_flexicontent_cats_item_relations` ON  `j25_flexicontent_cats_item_relations`.`itemid` = `j25_flexicontent_versions`.`item_id` 
				INNER JOIN  `j25_users` ON `j25_users`.`id` =   `j25_flexicontent_versions`.`created_by`
                                INNER JOIN `j25_flexicontent_fields` ON `j25_flexicontent_fields`.`id` = `j25_flexicontent_items_versions`.`field_id`
				WHERE  `j25_flexicontent_cats_item_relations`.`catid` 
				IN ( 85, 86, 87 ) 
				ORDER BY  `j25_flexicontent_versions`.`created` DESC

I need to show this for a client certification

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

igcorreia
Topic Author
Offline
Platinum Member

11 years 9 months ago #39663 by igcorreia

Replied by igcorreia on topic Help simple query

I struggled with pagination in the front end and know I am struggling with the unserialize hhehe.

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

igcorreia
Topic Author
Offline
Platinum Member

11 years 9 months ago #39664 by igcorreia

Replied by igcorreia on topic Help simple query

BTW I am using the new filters

LOVE them design lokking better.

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

ggppdk
Offline
Administrator

11 years 9 months ago #39668 by ggppdk

Replied by ggppdk on topic Help simple query

Hello

why is the category view not suitable?

e.g. if you do not need to tamper with category model
them

1, duplicate and customize:
view.html.php to view.htmlkk.php
... and use in your urls &format=htmlkk
(you must remember to append this variable inside your view.htmlkk.php) easy just find place where url is created !!

2. and also use a custom template

if you try to create a new frontend view you will end up doing a lot of work !!

PS: about filters (if you disable item counter they will not work ... it must be fixed)

ALSO, file field saving is broken in r1742, i will be posting a hotfix on SVN downloads

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