Hi Pierre,

Thank you for the pointer.  I have implemented the edit_filter.

In file plugins/edit/server/ServerEdit.php I added the function:

   /**
    * Gets the edit_filter from metadata
    * @return string edit_filter
    */
   protected function getFilter() {
$editFilter = $this->getMetadataValueString($this->layer, 'edit_filter');
       return $editFilter;

and then replaced this:
$sql = sprintf('SELECT *, astext(%s) as %s FROM %s.%s ' .
                                 'WHERE intersects (%s, ' .
"SetSRID('BOX3D(%s %s, %s %s)'::box3d, %s))",
                                 $this->geomColumn,
                                 $this->geomColumn,
                                 $this->editSchema,
                                 $this->editTable,
                                 $this->geomColumn,
                                 $shape->minx,
                                 $shape->miny,
                                 $shape->maxx,
                                 $shape->maxy,
                                 $this->getSrid()
                                 );

with this:
$sql = sprintf('SELECT *, astext(%s) as %s FROM %s.%s ' .
                                 'WHERE intersects (%s, ' .
"SetSRID('BOX3D(%s %s, %s %s)'::box3d, %s)) %s",
                                 $this->geomColumn,
                                 $this->geomColumn,
                                 $this->editSchema,
                                 $this->editTable,
                                 $this->geomColumn,
                                 $shape->minx,
                                 $shape->miny,
                                 $shape->maxx,
                                 $shape->maxy,
                                 $this->getSrid(),
                                 $this->getFilter()
                                 );

It is not perfect but it works.

Thanks,

Vid

Pierre GIRAUD wrote:

Hello,

I'm sorry but the "edit_filter" you probably found in the demoEdit project has no effect. It is never taken into account in the edit plugin. This would be a great enhancement. It was considered at first and proposed with this never used parameter. Though, no customer ask for it, so it has not been implemented.

I don't have any workaround to do this.

Regards

Pierre


Vid Bijelic wrote:

_______________________________________________
Cartoweb-users mailing list
[email protected]
http://lists.maptools.org/mailman/listinfo/cartoweb-users

Reply via email to