Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - alekib

1
Questions / Master-Detail: Prevent detail modification
Hi all,
i want to prevent modification (Add,Edit) of details in a Master-Details invoice system, based on status field.

Example:
Master field status="Ordered" then hide Edit and Add in details form.

Thanks.
3
General Discussion / Re: Search with OR option
Hi willvin,
thanks for reply but your answer dont fix my issue.
Still not filter record if i invert the search terms.

i have found this code but i dont know ho to implement this on list page  search fields

$str = yourinput;
$strarray = (explode(" ",$str));
$query = "SELECT * FROM table WHERE ";
Foreach($strarray as $key=>$value){
If($key > 0){
$query = $query . "OR";
}
$query = $query . " (name LIKE '%" . $value . "%') ";
}
$query = $query . "ORDER BY id ASC";

4
General Discussion / Search with OR option
Hi,
i have an issue on a list page search Field.

i have in a db field named faq_problem some text: examp. "error on row rp8"
if i search 'error rp8' not record  displayed.
if i search 'error % rp8' wil show the record.
if i search 'rp8 % error' not record displayed.

How i can edit the search function?

the sql is like this: SELECT * FROM table WHERE (name LIKE '%value1%') OR (name LIKE '%value2%') ORDER BY id ASC

thx.