使用联系人填充选择列表

发布于 2024-12-11 13:43:13 字数 873 浏览 4 评论 0 原文

我想使用 apex:selectList 来填充联系人。问题是它给出了一个错误

  Collection size 3,403 exceeds maximum size of 1,000

这是因为我有3403个联系人，而Vf对VF页面中的集合有限制。

我想将初始联系人集限制为 <1000，并且当用户开始输入我想要查询的联系人的字符时。例如，如果用户输入 Ji，我想查询联系人以检索以 JI 开头的记录。

这可以吗？

  <apex:selectlist id="ClientsSearch"  value="{!Appointment.Client__c}" 
       size="1" required="true" rendered="{!NOT (SearchMode)}">

  <apex:selectOptions value="{!Clients}" />
  </apex:selectlist>


 public List<SelectOption> getClients() {     
   List<SelectOption> options = new List<SelectOption>();
  List<Contact> Clients =  [Select id, Name From Contact order by Name];
  options.add(new SelectOption('0001', '--Select--'));
 for(Contact c : Clients ){
 options.add(new  SelectOption(c.id, c.Name));
 }
  return options;
 }

原文

I want to use a apex:selectList to populate contacts. The problem is that it gives an error

  Collection size 3,403 exceeds maximum size of 1,000

This is because i have 3403 contacts, and Vf has limitation on the collections in the VF page.

I want to limit the inital set of contacts to <1000, and as the user starts typing in the characters i would want to query the contacts. For ex if the user types in Ji i want to query the contacts to retrieve records starting with JI.

Is this possible to do?

  <apex:selectlist id="ClientsSearch"  value="{!Appointment.Client__c}" 
       size="1" required="true" rendered="{!NOT (SearchMode)}">

  <apex:selectOptions value="{!Clients}" />
  </apex:selectlist>


 public List<SelectOption> getClients() {     
   List<SelectOption> options = new List<SelectOption>();
  List<Contact> Clients =  [Select id, Name From Contact order by Name];
  options.add(new SelectOption('0001', '--Select--'));
 for(Contact c : Clients ){
 options.add(new  SelectOption(c.id, c.Name));
 }
  return options;
 }

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

伴随着你 2024-12-18 13:43:13

您可以在查询中使用通配符来执行此操作 - 因此您需要在页面中添加一个元素以允许他们输入搜索词，该搜索词写为到控制器中的字符串变量。然后添加一个搜索按钮来运行查询并使用新的联系人列表重新呈现列表。

控制器的重要部分如下所示：

public string SearchTerm {get; set;}
public list<ContacT> Contacts {get; set;}

public Pagereference SearchContacts()
{
    // etc.
    Contacts = [select Id, Name from Contact where name like : '%' + SearchTerm + '%' order by name limit 1000]; 
    // populate list here
    return null;
}

您可以使用操作函数执行搜索，并从输入字段的 onChange 事件触发它，但使用按钮进行搜索将使整个事情更加响应（IMO）从用户的角度来看。

注意：我即时编写了这段代码，您可能不能以这种方式将“%”与搜索词连接起来，或者在直接查询时甚至不需要这样做。通常在这些情况下，由于其他要求，我不得不使用动态 SOQL，在字符串中构建查询：

strQuery = 'select id from contact where name like \'%' +
    String.escapeSingleQuotes(SearchTerm) + '%\' order by name';
for(Contact sContact : Database.query(strQuery) ...

You can use wild cards in your query to do this — so you'll want to add an <apex:inputText> element in your page to allow them to enter a search term, which writes to a string variable in the controller. Then add a search button to run the query and re-render the list with the new list of contacts.

The important parts of the controller will look something like this:

public string SearchTerm {get; set;}
public list<ContacT> Contacts {get; set;}

public Pagereference SearchContacts()
{
    // etc.
    Contacts = [select Id, Name from Contact where name like : '%' + SearchTerm + '%' order by name limit 1000]; 
    // populate list here
    return null;
}

You could perform the search using an action function and firing it from the onChange event of the input field but having a button to do the search will make the whole thing more response (IMO) from the user's point of view.

Note: I wrote this code on the fly, it may be that you can't just concat '%' with the search term in this manner or maybe that you don't even need to when querying directly. Usually in these cases I've had to utilise dynamic SOQL due to other requirements, where you build up the query in a string:

strQuery = 'select id from contact where name like \'%' +
    String.escapeSingleQuotes(SearchTerm) + '%\' order by name';
for(Contact sContact : Database.query(strQuery) ...

回复收藏 0 原文

毁梦 2024-12-18 13:43:13

有几个选项可以获取您想要的功能。这取决于您想要的解决方案的复杂程度，但总有解决方案。

您可能需要考虑在控制器中使用 jQuery 和 SOSL（搜索语言）。以下是 Salesforce 中使用 Ajax API 进行 jQuery 自动完成的示例。点击下面的链接：
http://matthewkeefe-developer-edition.na8.force.com/jQueryAutocompleteWithAjaxAPI

另外，请查看 Tehnrd 的帖子“超酷高级查找组件"作为另一个选项。