Брзо и лако: Одредите интерни назив колони колони локације

УПДАТЕ: Џереми Тхаке has blogged about this and put up some code for a console application that shows internal names.

I was trying to get a content query web part to display a due date from a task and because the screen label is "Due Date", Претпоставио сам да је колона име за коришћење у <ЦоммонВиевФиелдс> is "Due_x0020_Date".

Погрешно!

The real column name in this case was "DueDate".

How did I find it? I re-read Heather Solomon’s blog entry on modifying CQWP to show additional columns of data. She describes this process at step #13. Trust it. It’s correct. Најмање, it was correct for me. I did not trust it at first for another column with a much longer name.

I say "Trust it" because I did not trust it and probably wasted near two hours butting my head up against a wall. After I resolved the "DueDate" име, I wanted to add another field to <ЦоммонВиевФиелдс>. Using the Solomon technique, I was getting a column name like "XYZ_x0020_Project_x0020_Due_x00".

I thought to myself, that’s clearly a truncated name. I went ahead and un-truncated it with no success. I finally used the seemingly truncated name and it worked.

Bonus tip: When I was working with the CQWP, if I added a bad internal name to <ЦоммонВиевФиелдс>, the CQWP would tell me that the query had returned no results. Али, if I added a data type to the field name, it would return a result. Adding the data type actually masked a problem since I was referencing a non-existent field. I could add it, but when I tried to display its value, I would always get a blank.

This did not mask the error:

<ЦоммонВиевФиелдс>Due_x0020_Date;</CommonViewfields>

This did mask the error:

<ЦоммонВиевФиелдс>Due_x0020_Date,DateTime;</CommonViewfields>

</крај>

3 мисли о "Брзо и лако: Одредите интерни назив колони колони локације

  1. Кори
    Using the "hover" technique isn’t too bad for one or two fields. But for massive lookups I use the Stramit Caml viewer веза. I actually like that one better than the U2U one — it’s very quick and it’s got the nice feature of returning the CAML as StringBuilder code.

Леаве а Репли

Ваша емаил адреса неће бити објављена. Обавезна поља су означена *