is it possible to filter a uniDBTreeGrid with SQL

[erich.wanker]

How can i make a  SELECT * FROM maintenance_asset where my_nodename ="buildings" AND userright containing "e4" order by Node_id

 

Is something possible? .. 

[MarcoPis]

Hi, do you have a linked datasource?

Standalone or Isapi?

[erich.wanker]

Hi,

Standalone .. unigui-exe with hyperserver on Apache...

1 table with all informations: maintenance_asset 

    ' `id` INT(8) UNSIGNED AUTO_INCREMENT PRIMARY KEY,' +
      ' `inr` INT(8) UNSIGNED,' +
      ' `dummy` VARCHAR(1) ,' +
      ' `category` VARCHAR(50),' +
      ' `idfield` INT(8) UNSIGNED,' +
      ' `idparentfield` INT(8) UNSIGNED,' +
      ' `my_nodename ` VARCHAR(200),' +
      ' `asset_name` VARCHAR(200),' +
      ' `asset_id` INT(8) UNSIGNED,' +

....