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

УПДАТЕ: Џереми Тхаке 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.

Оставите одговор на Паул Галвин Откажи одговор

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