Dynamically setting View Query

rss

Posted by mac_xpert - Jan 16 ’15 at 05:21

Hi I'm using your Related items Lookup on a large list of contacts. Each contact in the list has an associated project. Im trying to lookup the contacts associated with a project.

This works fine for lists of less than 5000 items but on large lists i get no results.

My thought is that if i could in someway dynamically set the Query used in the view of this lookup to match the project name in the form to the project name in the list it would dynamically create a view of less then 5000 items and the related items lookup would work.

I can view the code of the view in SPForms Designer under Extended>View:

<View>
<ViewFields>
<FieldRef Name="Edit" />
<FieldRef Name="Title1" />
<FieldRef Name="FirstName" />
<FieldRef Name="LastName" />
<FieldRef Name="JobTitle" />
<FieldRef Name="ol_Department" />
<FieldRef Name="CompanyLookup" />
<FieldRef Name="ClientOffice" />
<FieldRef Name="Created" />
<FieldRef Name="Modified" />
</ViewFields>
<ViewData />
<Query>
<Where>
<Eq>
<FieldRef Name="FirstName" />
<Value Type="Text">Matthew</Value>
</Eq>
</Where>
</Query>
<Aggregations Value="Off" />
<RowLimit Paged="TRUE">30</RowLimit>
<Mobile MobileItemLimit="3" />
<Toolbar Type="Standard" />
<XslLink Default="TRUE">main.xsl</XslLink>
<JSLink>clienttemplates.js</JSLink>
</View>

 

But is it possible to change the value of <Value Type="Text">Matthew</Value> in the query to match the content of a field in the form?

 

Thanks for your help.

 

Matt.

  • jamesthomas6
    Member
    Member for: 10 months 8 days
    #11 by jamesthomas6 Mar 15 ’21 at 04:06

    We have seen that money application clients go through different kinds of issues every day. Among which the <a href="https://www.email-contactsupport.com/blog/cash-app-wont-let-me-send-money"><b>Cash app won't let me send money</b></a> is exceptionally basic nowadays. On the off chance that you need to fix this issue, you should contact our deft specialists. They will geode you the authority path through which you can fix these issues quickly.

  • jamesthomas6
    Member
    Member for: 10 months 8 days
    #12 by jamesthomas6 Mar 15 ’21 at 04:08

    Cash app has customers support experts who have good knowledge of this application. If you don’t carry a card then you can contact them to get money off Cash App without card. They will tell you the easy yet official way to process a cash out from the convenience of your home. Also, you can avail of these services from us at affordable prices.

  • jamesthomas6
    Member
    Member for: 10 months 8 days
    #13 by jamesthomas6 Mar 15 ’21 at 04:09

    The easiest way to get a refund of a Cash app payment pending is to cancel the transaction. You can open the activity tab on the cash app and follow the guidance of our professionals to cancel a payment. Moreover, they will also guide you to raise a refund request or chargeback, in case the payment gets settled. Also, customers can avail of this service from us at feasible prices.

  • jamesthomas6
    Member
    Member for: 10 months 8 days
    #14 by jamesthomas6 Mar 15 ’21 at 04:10

    We have seen that money application clients go through different kinds of issues every day. Among which the Cash app won't let me send money is exceptionally basic nowadays. On the off chance that you need to fix this issue, you should contact our deft specialists. They will geode you the authority path through which you can fix these issues quickly.​

Displaying 11 to 14 of 14 messages