It worked! At least I managed to make a simple search form. I will experiment a bit and I might come back with any questions if needed. 

Kind regards, 

Andreas

Ok, when the generate the view code you can either check the "Allow Searching" checkbox, or manually set that option to true in the generate code as follows:

'allowSearch' => true,

You can create a special link that only lists specific records. Just add a ("?") after your url, following by the search conditions (fieldname=value).
Example: listViewer.php?color=blue

Multiple search conditions can be combined with ("&").
Example: listViewer.php?color=blue&size=XXL

Those search for exact matches, but if you add _keyword to the end it will check for the search term anywhere in the content:
Example: listViewer.php?title_keyword=ai

You can create search forms by naming the fields after what you want them to search. Here is a simple search form that searches the "title" field for a keyword.

<form method="POST" action="?">
<input type="text" name="title_keyword" value="">
<input type="submit" name="submit" value="Search">
</form>

 I'd recommend experimenting with modifying the URL and creating forms and refer to our search documentation here: 
https://www.interactivetools.com/docs/cmsbuilder/viewer_search.php

Hope that helps! Let me know any other questions.

Thank you for your interest. 

I refer to the list of records created with the PHP viewer code. When I open the file, I see a list of the total number of records of the section. I would like to add some PHP code in the beginning to make some filtering of the returned results.

I hope it makes sense. If it does not, I can provide you with the code or some username/password to log in to this page (it is not free; one needs to log in through the Website Membership plugin to have access to this page). 

Kind regards, 

Andreas

Are you referring the the list of records in the CMS itself? Or the list of records you see when you create viewer code and are viewing that PHP file through the browser? 

Let me know and I'll try to help, thanks!

Is there any available PHP code to make a simple search within my section list-page?

Regards, 

Andreas

Is there any available PHP code to make a simple search within my section list-page?

Regards, 

Andreas

There's some examples here for creating search fields: https://www.interactivetools.com/docs/cmsbuilder/viewer_search.php

What fields do you want to search on and what do you want it to look like? 

Perhaps someone else reading this might have ideas or you could contact Interactive Tools consulting.

~ Deborah

Unfortunately, I have not been able to manage it as I expected. I am thinking of adding some PHP code inside this list-page (already filtered to contain only records created by the logged in user) that will allow users to search within it using various criteria. Is there some code available?

Regards, 

Andreas

Depending on what you have in mind for search, one of these methods might work.

1) There's a variety of search methods in the CMS Builder documentation here:
https://www.interactivetools.com/docs/cmsbuilder/viewer_search.php

2) To search multiple tables on one page, you can try MultiSearch.php referred to in this forum post:
https://www.interactivetools.com/forum/forum-posts.php?postNum=2246137#post2246137
There's a download link to MultiSearch.php at the bottom of the second post.

Hope that helps!
~ Deborah

Thank you for your reply. 

It seems it works. 

  // load records from 'aortic_aneurysm_disease'
  list($aortic_aneurysm_diseaseRecords, $aortic_aneurysm_diseaseMetaData) = getRecords(array(
    'tableName'   => 'aortic_aneurysm_disease',
    'perPage'     => '10',
    'loadUploads' => false,
    'allowSearch' => true,
    'where' => mysql_escapef('createdByUserNum = ?', $CURRENT_USER['num']),
  ));

What about a search query to search within the file?

Kind regards, 

Andreas

I've not tried this myself, but the last post on the following forum thread might help.
https://www.interactivetools.com/forum/forum-posts.php?postNum=2245779#post2245779

Looks like basically this might do it:

'where' => mysql_escapef('createdByUserNum = ?', $CURRENT_USER['num']),

~ Deborah

I have created the List page of a section with the code generator tool and made all the additions described in the Website Membership plugin so that each user should log in to have access to this page. And this works fine. So when a user logs in with his username/password he/she has access to this specific section list page. However, he/she has access to the full set of records and not only to those records he/she has created. This is something I want to avoid as each user should have access only to his/her records. 

Can you give me some hints on how to carry on? (Just to remind that each user can have one of three different distinct types of access to records - own, hospital, all-). 

And an extra question. As this List page will contain a very large number of records, how could I add a search tool (either at the beginning of the page or on a different page) to filter the retrieved records according to some criteria?

Kind regards, 

Andreas Lazaris