[Paul Heffner]

VQName – This is the name of the field the user will search up
Current_x0020_Flag – Boolean to ID current record
Attribute1 – First field that I would like to autopopulate.

the rest of the fields are Attribute2 through Attribute12

There are also StartDate and EndDate fields but I think the Current Flag is what I want to look at.

[Paul Heffner]

Thank you for the fast reply. I have the active part working but still having trouble with the membership

<Where><And>

<Eq><FieldRef Name='Active' /><Value Type='Text'>Yes</Value></Eq>

<Eq><Membership Type=\"CurrentUserGroups\ "><Value Type='Text'>MIS Reporting Owners</Value></Membership></Eq>

</And></Where>

This is assuming the group name is MIS Reporting Owners

[Paul Heffner]

I finally got it working without limiting the list. Now, I need to show the items where today is between the “Request Date” and “Decision Date”.

[Paul Heffner]

seems I can’t get the lookup working even without the CAML. What is error 80020101?

I have gone over the example and input my values but can’t seem to get it.

[Paul Heffner]

Thank you for the reply. I do not know CAML but I am willing to learn. I have a strong background in SQL. When adding the CAML to filter, what tags do I need? Should I start with <query> or just <where>?

[Author]

Posts