jQuery Grid Plugin - jqGrid - Topic: onempty set values from childs to parent http://www.trirand.com/blog/?page_id=393/help/onempty-set-values-from-childs-to-parent Simple:Press Version 5.7.5.3 OlegK on onempty set values from childs to parent http://www.trirand.com/blog/?page_id=393/help/onempty-set-values-from-childs-to-parent#p15712 Help http://www.trirand.com/blog/?page_id=393/help/onempty-set-values-from-childs-to-parent#p15712 Ohhh. This question is really not for the jqGrid forum! But you can fill city-table based on SQL statement like

SELECT
    name,
    CASE WHEN city.lat IS NULL
         THEN country.lat
         ELSE city.lat
    END,
    CASE WHEN city.lon IS NULL
         THEN country.lon
         ELSE city.lon
    END,
FROM city
    INNER JOIN country ON city.countryId=country.id

Regards
Oleg

]]> Mon, 15 Mar 2010 18:57:03 +0200 bas_vdl on onempty set values from childs to parent http://www.trirand.com/blog/?page_id=393/help/onempty-set-values-from-childs-to-parent#p15703 Help http://www.trirand.com/blog/?page_id=393/help/onempty-set-values-from-childs-to-parent#p15703 i can do the logic on the server... any idea how to easily join and get the right results if city doesn't have a lat/lon value?

]]> Mon, 15 Mar 2010 16:32:25 +0200 OlegK on onempty set values from childs to parent http://www.trirand.com/blog/?page_id=393/help/onempty-set-values-from-childs-to-parent#p15701 Help http://www.trirand.com/blog/?page_id=393/help/onempty-set-values-from-childs-to-parent#p15701 It's depend on how you implemanted your master/detail example. The natural way could be place in the country grid onSelectRow event. In the event handle you could change some parameters of details grid (city grid) like title, url with respect of setCaption, setGridParam or some other methods. Then you call trigger(“reloadGrid”) on details grid. You can also use getRowData inside of event handle to get all information from selected master row.

All logic about reading latitude/longitude from the parent (country) can do your server.

If you don't have any server part of your program, you could do all works in javascript also.

I recommend look at http://trirand.com/blog/jqgrid.....qgrid.html choose Advanced and "Master Detail".

Best rebards
Oleg

]]> Mon, 15 Mar 2010 16:29:14 +0200 bas_vdl on onempty set values from childs to parent http://www.trirand.com/blog/?page_id=393/help/onempty-set-values-from-childs-to-parent#p15694 Help http://www.trirand.com/blog/?page_id=393/help/onempty-set-values-from-childs-to-parent#p15694 Hi guys,

i'm new to jqgrid. i just build my firs grid incl. a subgrid. the parent grid is a grid with countries, the subgrid is a grid with cities. for the country i have set the latitude/longitude value. for some cities i don't have this information.

in the grid i want to show the latitude/longitude for the cities. but when this value is empty i want to show the latitude/longitude from the parent (country).

how to do this?

thank you in advance!

the data is saved in a database. two tables (country [id, name, lat, lon], city [id, countryId, name, lat, lon])

]]> Mon, 15 Mar 2010 11:16:34 +0200