I have a Data View Part pulling from a list that has a lookup column to another list (title linked by ID)
And somewhere in the XSLT, it reads
Now since ColumnX is a reference to another list, how do I go about obtaining the ID rather than the text? Is there a ddwrt trick out there?
Note If you were to run the same CAML used by the Data View Web Part, you will notice that the ID of the referenced column is part of the result. E.g.
ows_ColumnX 12;#Bill Peet 13;#Erdman
ps: It seems and I could be wrong that the DVWP removes the IDs so things like substring-before(string, string) won't work.