How to get values remote_ip from table sales_flat_order?

[Agypten]

Hello! I`m trying in module to get values "remote_ip" from "table sales_flat_order", but nothing to showing. Another (email, order id) - show in orders grid.  My code (observer.php)

protected function prepareOrderCollectionJoins(&$collection, $orderItemsColumns = array()){
...............................................................................................
if ($showCustomerIP){
            $collection->getSelect()->join(
                array(
                    'order' => $collection->getTable('sales/order')
                ),
                'main_table.entity_id = order.entity_id', 
                array(                    
                    'order.remote_ip as xm_remote_ip'
                    )
            );
        }
.......................................................................................

}
    
    protected function prepareGrid(&$grid, $export = FALSE){
...................................................................................................
if (intval($showCustomerIP) > 0){
            $grid->addColumn('xm_customer_ip', array(
                'header' => Mage::helper('amogrid')->__('Customer IP'),
                'index' => 'xm_customer_ip',
                'width' => 80,
                'filter_index' => 'order.remote_ip'

            ));
        }
.................................................................................................
}

Anybody help?

 UPD. I found my errors. This is update code.

$grid->addColumn('xm_remote_ip', array(
                'header' => Mage::helper('amogrid')->__('Customer IP'),
                'index' => 'xm_remote_ip',

[Rakesh Jesadiya · Accepted solution]

@Agypten,

Please verify with your order if order was placed using Admin panel,

If order placed using admin panel, at that time remote_ip field will emtpy otherwise order placed using frontend remote ip will display based on customer remote ip.

So please verify above scenario and check again.

If issue solved, Click Kudos/Accept as solutions.