[mapguide-users] Filter on joined database values (was: invalid XML document)

[Kenneth Skovhede, GEOGRAF A/S]

IIRC, something is broken, so you can't filter on a joined database.
Instead, you can select keys from the database with an sql like this:
select distinct key from table where somecolumn = 'somecriteria';

The sql should then give you a list of keys.
You can then set the layer filter like this:
"ID" IN (...comma seperated key list...)
ea: "ID" IN ('1','A')

Regards, Kenneth Skovhede, GEOGRAF A/S



irwan skrev:
> I have succesfully implement the code into my current mapguide exercise.
> Based on the code above, i filtered the layer based on the attribute contain
> at sdf file. How about filtering based on the database query? how to pass
> value from database to xml file?
>