Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)
  • Search:

    Search seems to work, but my filter is probably wrong syntax (will have to check pods.io doc). Not too sure my WHERE clause working here now NOT LIKE (something I can resolve).

    Search DOES traverse through all pages, so that is perfect.

    Any search beats no search!

    Pods in Page (classic editor):

    [pods name=”user” pagination=”true”  limit=”10″ pagination_location=”before”  search=”true” filters=”last_name.meta_value” where=”active.meta_value like ‘1’ and user_login NOT LIKE ‘dave%’ and user_login NOT LIKE ‘kelly'” orderby=”last_name.meta_value” template=”Member List”][/pods]

    Thank you for the replies and help!

    Location does not seem to modify. Stays on the bottom.

    Pods used in Page (classic editor):

    [pods name=”user” pagination=”true”  limit=”10″ pagination_location=”before”  search=”true” filters=”last_name.meta_value” where=”active.meta_value like ‘1’ and user_login NOT LIKE ‘dave%’ and user_login NOT LIKE ‘kelly'” orderby=”last_name.meta_value” template=”Member List”][/pods]

    Template:

    [before]
    <div style=”overflow-x:auto;”>
    <table id=”customers”>
    <thead>
    <tr class=”pods-th”>
    <td>GVR NO</td>
    <td>First Name</td>
    <td>Last Name</td>
    <td class=”pods-tr-alignctr”>Res</td>
    <td>Email</td>
    <td>Phone</td>
    <td>Pd Thru</td>
    </tr>
    </thead>
    <tbody>
    [/before]
    <tr>
    <td>{@user_login}</td>
    <td>{@first_name.meta_value}</td>
    <td>{@last_name.meta_value}</td>
    <td class=”pods-tr-alignctr”>{@annual_member.meta_value}</td>
    <td>{@user_email}</td>
    <td>{@phone1.meta_value}</td>
    <td>{@paid_through.meta_value}</td>
    </tr>
    [after]
    </tbody>
    </table>
    </div>
    [/after]

    Pods v(all sites): Version 2.7.15

    PS: Will open new topic going forward.

    Replying to SEARCH separtely

    Now being fussy! Is there a search feature available for the Report List?

    Our sites do have a Search Function with plugin = Ivory Search, but do not see feature to search at that level. Maybe I can add one of their searches to the report, and if I find it, will add details here.

    Thank you

    If I may comment please.

    Just saw this post and added it to a DEV server and production server.

    On the DEV it displays the 1 2 3 5 Next › Last » on the top.

    On the production it displays the 1 2 3 5 Next › Last » on the bottom.

    The Production uses a template for all html & css, and only this line in the Page:

    [pods name=”user” pagination=”true” limit=”10″ where=”active.meta_value like ‘1’ and user_login NOT LIKE ‘dave%’ and user_login NOT LIKE ‘kelly'” orderby=”last_name.meta_value” template=”Member List”][/pods]

    Behavior is same if classic or gutenberg block.

    DEV has 34 recs, production 55 recs.

    Not an issue at all, just an observation.

    BTW, the pagination function is a huge PLUS!

Viewing 4 replies - 1 through 4 (of 4 total)