Using separate connector.php and update.php

Suite and Optimus Suite 5
#1

I am trying to make a grid that is updatable, but has a read-only column that is not updatable.

The read-only column is a link that is constructed using a custom render_sql statement in the connector.php file.

Everything works when it is read-only, but when I try to update the grid, it doesn’t update. I think that it is because the connector.php file doesn’t know how to handle the constructed field.

My sql statement is something like this:
$grid->render_sql(Select ID,ItemNo,CONCAT(t1.FullName,"^/_php/dhtmlxPro/ico_InventoryShipments/ico_ItemDetail.php?itemno=",ItemNo,"^_self") AS CF3 FROM inventory",“ID”,“ID,ItemNo,CF3”

The CONCAT builds the correct url.

Is there a way to mark a column as unreadable? Or is there an example showing how to use a different update.php file to update only those columns that should be updated?

Thanks!

#2

You can use

function remove_construct($action){ $action->remove_field("CF3"); } $grid->event->attach("beforeProcessing", "remove_construct")

It will exclude CF3 field from all data operations