Col_filter col_name different from or all but - simple way to do?

[egw-cw]

Hi,

I understood that $query[‘col_filter’][‘col_name’] generate a SQL query that look at all the matching values for col_name data.

I would like to do a query for “all but” this values for this col_name, or say all rows where the col_name value is different from the values I compare with.

Does somebody knows a simple way to do this ? something like $query[‘col_filter’][’! col_name’] ??

Thank you for your help.

[Raphael_Alla-2]

you can as well add actual sql in $sol_filter. For instance, you can write:
$query[‘col_filter’][] ="'col_name != ‘$value’"

I am unsure whether you can mix the two forms in col_filter.

Hi,

I understood that $query[‘col_filter’][‘col_name’] generate a SQL query
that
look at all the matching values for col_name data.

I would like to do a query for “all but” this values for this col_name, or
say all rows where the col_name value is different from the values I
compare
with.

Does somebody knows a simple way to do this ? something like
$query[‘col_filter’][’! col_name’] ??

Thank you for your help.

View this message in context:
http://www.nabble.com/col_filter-col_name-different-from-or-all-but---simple-way-to-do---tp15268875s3741p15268875.html
Sent from the egroupware-developers mailing list archive at Nabble.com.

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Raphael Alla
Mitija Australia
+61 4 15 678 576
+687 78 86 86
http://www.mitija.com