Alpha pagination of objects

Thursday 04 September 2003 1:14:56 am

Are you saying you have a way to return search results according to pagination, or that you have a problem with handling that many results?

For the size of results can you use the offset feature found in the advancedsearch scripts?

Paul

Thursday 04 September 2003 3:04:28 am

Just noticed a typo in my post. I meant to ask if you *didn't* have a way of identifying which objects started with your letter of choice... Though i guess thats what you mean now.

Looking in the doco for fetch:

http://ez.no/developer/ez_publish_3/documentation/development/libraries/ez_template/operators/data_fetch

With 3.2 you can return results from a fetch by attribute. Now, it is feasible to return a list of objects by pattern matching on their name, like so:

fetch( 'content', 'list',
--------hash( parent_node_id, <node to start search from>,
----------------attribute_filter,
-------------------------array( 'or', array( <attribute id>, '=', 'a*' ),
--------------------------------------array( <attribute id>, '=', 'A*' ) )
--------------)
-------)

Here <attribute id> is the class attribute. ez3.2 displays this number if you edit the class you wish to sort by...

Now, im not sure this will work, but its worth a try :)

Hope you see what im doing here.

paul

Monday 08 December 2003 12:13:17 pm

The code below works for selecting nodes which attribute nr. 181 begins with k.

Hix

{section loop=fetch( 'content', 'list', hash( parent_node_id, 1118 , attribute_filter, array( 'or', array( 181, '>=', 'k' ) )) ) }

<a href={$:item.url_alias|ezurl}>{$:item.name}</a><br>

{/section}

Thursday 08 September 2005 10:14:15 am

Hi,

I've got this half working with:

                {set list_items=fetch_alias( children, hash( parent_node_id, $node.node_id,                                                             offset, $view_parameters.offset,                                                             sort_by, $node.sort_array,
'attribute_filter', array( 'or', array( 'person/last_name', '>=', 'a' )), 			
limit, $page_limit ) )}

but the problem is that this fetches last_name that include 'a', not those that start with the letter 'a'.

I've tried wildcards 'a*' with no joy...

For me Jakub's code above doesnt work, tho' I'm building on 3.6 and his comment is from 2003...

Any ideas on this one?

Thanks, Steve.

http://www.oneworldmarket.co.uk

Friday 09 September 2005 1:00:02 am

Kristof,

Thanks for your reply. I have tried with the 'like' op but with no success.

Some combinations I've tried are:

Returns no results:

'attribute_filter', array( 'or', array( 'person/last_name', '=', 'A%' ) ),

'attribute_filter', array( 'or', array( 'person/last_name', '=', 'A*' ) ),

'attribute_filter', array( 'or', array( 'person/last_name', '=', 'A' ) ),

'attribute_filter', array( 'and', array( 'person/last_name', '=', 'A*' ) ),

'attribute_filter', array( 'and', array( 'person/last_name', '=', 'A' ) ),

Returns everything:

'attribute_filter', array( 'or', array( 'person/last_name', '>=', 'A' ) ),

'attribute_filter', array( 'or', array( 'person/last_name', '>=', 'A%' ) ),

'attribute_filter', array( 'and', array( 'person/last_name', '>=', 'A%' ) ),

I just cant get it to filter by the first letter only :(

I'm wondering, do I need to use '=' and tweak the 'first-letter+wildcard' combination? I cant see any info on wildcards in docs or forum.

Steve.

http://www.oneworldmarket.co.uk

Friday 09 September 2005 1:33:55 am

I've made a mistake. The wildcard filter in the "like" filter operation is * instead of %.

So the correct code is:

{set list_items=fetch( content, list, hash(
    parent_node_id, $node.node_id,
    offset, $view_parameters.offset,
    sort_by, $node.sort_array,                                                                                                       
    attribute_filter, array( 
        'or',
        array( 'person/last_name' 'like', 'a*' ) 
        ),
    limit, $page_limit
    )
)}

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Friday 09 September 2005 4:57:30 am

This works for me:

{default fra=$view_parameters.fom
         til=$view_parameters.to}


{let children=fetch( content, list, hash( parent_node_id, $node.node_id,                      attribute_filter, array('and',array(241,'>='$from),array(241,'<=',$to))))

You'll have to adjust 241 to your attribute, of course.

Wednesday 14 September 2005 9:46:18 am

Hi,

Well, you have to laugh... Now I've got the reverse problem, have got the code giving results but it wont filter the results at all :)))

Kristof, your code needed an extra ',', so:

array( 'person/last_name' 'like', 'a*' )

is

array( 'person/last_name', 'like', 'a*' )

Now I get results returned, but it gives the whole list. The current fetch I have is:

 {set list_items=fetch_alias( children, hash( parent_node_id, $node.node_id,                                                             offset, $view_parameters.offset,                                                             attribute_filter, $time_filter,			 array( 'or', array( 'person/last_name', 'like', 'a*' )),                                                          sort_by, $node.sort_array,                                                             limit, $page_limit ) )}

Like I say, it just doesnt filter at all now :-/ I get a full set of results.

I've added the

Parameter[attribute_filter]=attribute_filter

into the fetch_alias files...

Any other thoughts on this conundrum?

Thanks, Steve

http://www.oneworldmarket.co.uk

Thursday 15 September 2005 2:42:38 am

Hi Steve,

I had the same problem once...
Read carefully...
'attribute_filter', array( [condition] )
'attribute_filter', array( 'person/last_name' 'like', 'a*' )
or
'attribute_filter', array( array( [logic], [condition1], [condition2] ) )

'attribute_filter', array( 'or', array( 'person/last_name' 'like', 'a*' ), [cond2] )...

so in your code [condition2] was missing completly.
But it looks like you don't need it at all.

Cheers Christiane

Thursday 15 September 2005 7:32:58 am

Just found this post:

http://ez.no/community/forum/general/probleme_with_a_href

Has the caching reolution...

http://www.oneworldmarket.co.uk