How can I do this ? (DB select)

How can I do this ? (DB select)

Sunday 18 May 2003 2:51:05 am - 7 replies

Author Message

Paul Forsyth

Sunday 18 May 2003 3:06:03 am

Have you looked at using workflows? You can specify when classes become unpublished.

Paul

Selmah Maxim

Sunday 18 May 2003 4:37:23 am

I know, but to make it as cron job is faster and easier than make new workflow, what u think ?!

Selmah Maxim

Sunday 18 May 2003 5:57:10 am

I gived up :(

Paul ..

can give more info please ?!

Paul Forsyth

Sunday 18 May 2003 7:01:00 am

oops, sorry, posted to the wrong forum :(

heres what i wrote:

Workflows uses a cronjob as the underlying mechanism to affect the database. So you can schedule your ez cronjob to run whenever.

have a search for workflow on the forums. lots of info like this:

http://ez.no/developer/ez_publish_3/forum/setup_design/workflow

hope it helps

Selmah Maxim

Sunday 18 May 2003 7:09:30 am

i had read it befor, i had read all what i found in the serach with this words 'workflow+approve' , but i didn`t get the point of unpublish, publish workflow !

now am trying to write check exp. workflow, coz i don`t think the publish or unpublish do the job.

Paul Forsyth

Sunday 18 May 2003 7:31:29 am

From what i understand of what you want to do workflow is the best way.

With it you can select the articles, choose to unpublish them at a given date, and the cronjob will run and perform the checks. When the date is reached the articles will be unpublished.

Have you attempted to use workflows yet?

Selmah Maxim

Sunday 18 May 2003 8:22:28 am

yes ... i had tried the publish and unpublish workflow, the publish have (Unpublish object, Publish object) , nice but what come after this ?

and Unpublish ?

were to set when to publish or unpublish ?

which workflow to choose ?

in my class there are enum, which have 3 value timestamp for 3,6,12 month, so if i add this value to the published timestamp i`ll get the exp. date, how make workflow check this ?

now am trying to write my own workflow, but is very complex for me the DB structure , i cann`t unserstanted it to make query from it, also i cann`t catch which class is used for fetching the data map in the template systems to use it in the custom workflow ...

really sad, also i found bug, for my is really big bug, that when you delete anything from the adminface will not be detele from all tables, so after while the site will come slow, and the search will be deadly slow, coz alot of unwanted trash in the db :(

i don`t what think about Ez, but for me it`s come clearly that they don`t get money from selling the code, or building sites, it`s coming from the support, and only the support, i was thinking to ask them for some custom workflow and for more addons for ez32, but it`s cost alot, much better to write my own script and developering it slowly ...
I had worte my script, but i stop it, coz i counted what time i need to finish it, and testing , so i thoght if i start from ez32 will be faster, but am up set now ....

but i`ll keep trying to figure it out, coz is tested as code, i`ll need to change alot to figure what i need from it .

I hope i`ll finish befor Ez4 :)

now any help please ?

You must be logged in to post messages in this topic!

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.