createdByUserNum and rule to rewrite

Hi Djulia,

To have CMS Builder do the search for records created by a user automatically, you need to have the "createdByUserName" in the url.

However, you can format the URL string to anything you like, so long as you have the record number (in your example 3) at the end of the url string like this:

xxx.php?page=2&userName-3

This will not do the search automatically, but you can then change your getRecords statement to use this line:

'where' => "createdByUserNum=".getNumberFromEndOfUrl(0),

Hope this helps.

Hi Jason,

Thank you!

Your solution is good.

But, it would be possible to modify the value of prevPageLink and nextPageLink ?

Currently, I obtain for : user.php?&userName-3

$listingMetaData['nextPageLink'] ==> user.php?userName-3=&page=2
$listingMetaData['prevPageLink'] ==> user.php?userName-3=&page=1

Thanks again. :)

Djulia

Hi Jason,

The post of Dave helped me to find a solution.
http://www.interactivetools.com/forum/gforum.cgi?post=58611#58611

<?php
//
$str = @$_SERVER['REQUEST_URI'];
parse_str($str, $output);
$user = array_keys($output);

$pageLink = "{$user[1]}";
$listingMetaData['prevPageLink'] = "{$_SERVER['PHP_SELF']}?page={$listingMetaData['prevPage']}&{$pageLink}";
$listingMetaData['nextPageLink'] = "{$_SERVER['PHP_SELF']}?page={$listingMetaData['nextPage']}&{$pageLink}";
$listingMetaData['firstPageLink'] = "{$_SERVER['PHP_SELF']}?page=1&{$pageLink}";
$listingMetaData['lastPageLink'] = "{$_SERVER['PHP_SELF']}?page={$listingMetaData['totalPages']}&{$pageLink}";
?>

Thanks to have taken the time to answer me ! :)

Djulia