I'm using a list controller and a parent-to-child query to return a fairly simple list of parent records and their associated children. Note that the children have a lookup relationship to the parent. I want to filter the children in the child query using "in" criteria, but I keep getting this error:

Variables__r where Variable_Master__c in :this.vmIds) from Account ^ ERROR at Row:1:Column:106 unexpected token: ':'

It looks like this type of filter doesn't work in child relationship queries in a list controller.  I know vmIds is a valid list because I use it elsewhere without a problem.

This errors:

setCon = new ApexPages.StandardSetController(Database.getQueryLocator([select Id, Name, (select Id, Account__c, Variable_Master__c from Variables__r where Variable_Master__c in :this.vmIds) from Account where Name like :this.queryAcct and Status__c = 'Active' order by Name]));

 This works:

setCon = new ApexPages.StandardSetController(Database.getQueryLocator([select Id, Name, (select Id, Account__c, Variable_Master__c from Variables__r) from Account where Name like :this.queryAcct and Status__c = 'Active' order by Name]));

 This also works:

setCon = new ApexPages.StandardSetController(Database.getQueryLocator([select Id, Name, (select Id, Account__c, Variable_Master__c from Variables__r where Variable_Master__r.Name like 'S%') from Account where Name like :this.queryAcct and Status__c = 'Active' order by Name]));

Anyone ever seen something like this?  I first built a version that returned a simple list (didn't use a StandardSetController) and while that worked, I occasionally got record sets that were too large.  So I changed it to the list controller and started seeing this problem.  It's only when I use the colon notation that it errors, looks like a bug.

I've run into some issues after the summer 09 update changing the behavior of commandButton/commandLink rerenders and it behaves differently in Firefox vs. IE. I've got a pageBlockTable with one column containing a "Copy" commandLink and the next column containing an inputField. Clicking the Copy link will copy the value from the inputField on that row to all other objects in the list. The commandLink then refreshes the pageBlockTable only so the copied values are displayed to the user. This much works perfectly in both Firefox and IE.

However IE goes a step further. After refreshing the pageBlockTable and displaying the copied values correctly, it then refreshes the entire page. Problem is, this causes the original queries to re-fire and all the object values are returned to their original values and the user's "copy" is wiped out before their eyes. This second refresh does not happen in Firefox.

<apex:pageBlockTable id="avlist" value="{!accountVariables}" var="av">
<apex:column headerValue="Copy">
<apex:commandLink value="Copy" action="{!copyFieldValue}" status="accountcopy" rerender="avlist" rendered="{!IF(contains(av.Category__c, 'Account'), 'true', 'false')}">
<apex:param name="avarid" value="{!av.Account__c}"/>
<apex:actionSupport event="oncomplete" status="accountsuccess"/>
</apex:commandLink>
</apex:column>
<apex:column headerValue="{!av.FieldID__c} {!av.Variable_Master__r.Name}">

<apex:outputPanel id="editvalue" rendered="{!IF(AND(OR(av.Type__c='Image',contains(av.Type__c, 'Text')), contains(av.Category__c, 'Account')), 'true', 'false')}">
<apex:inputField value="{!av.Value__c}"/>
</apex:outputPanel>

</apex:column>
</apex:pageBlockTable>

I'm not sure if this is a cache issue, but it sure looks like something on the client side which is strange.  I have a VF page with a fairly complex layout for formatting purposes, that includes information from multiple related objects as well as two pageBlockTable tags.  It uses a custom controller to return various things.  This page allows the user to view the joined information and then "confirm" it for production.  The VF page is launched in a popup window from an scontrol page using a link like this:

window.open('/apex/orderConfirmation?scontrolCaching=1&id='+oliId+'&pid='+pid,'mywindow','width=1024,height=768,scrollbars=yes,menubar=yes,toolbar=yes');

The problem is, my IE7 users can run this VF page about 5 times and then the popup window will simply freeze and remain blank.  Closing IE7 and relaunching it solves the problem for another 5 times.  I'm looking at some IE7 settings but haven't solved it yet. FWIW I have run this confirmation page myself over 90 times in a row using Firefox and have not had the problem.  Do you think launching the VF page from an scontrol could cause this problem?

Mark

I'm getting this error seemingly at random on a new VF page I've been working on.  Sometimes the page works just fine and others the error occurs, even when performing exactly the same operation.

Error ID: 206982387-929 (-1994354179) 

The page is used to create junction records between the Account table and a custom Zip Code table, creating a many-to-many relationship.  I've read that there were some issues with junction objects and competing Master relationships, but not sure if this is the case here.   What does this error indicate?  Thanks.

Mark

I wasn't sure where to post this since it's a bug in the Data Loader that involves semi-joins and parent/child subqueries, and I will log a case with it too.  Anyone else seen this?  I'm trying to put together a very simple semi-join query that works just fine against the API in Eclipse, but fails with an "invalid query" error in the Data Loader.

select Id, Name, (select Id from Tasks) from Opportunity where Id in (select OpportunityId from OpportunityLineItem where Description = 'test')

If I remove the child sub-query it works fine in Data Loader, and the full query with the child query works fine in Eclipse.  Looks like a bug in Data Loader on query validation.

Mark

I've searched a lot of similar posts but can't come up with the solution I need.  I need to present a table to the user where the number of columns and rows is unknown until runtime.  I could create something that has all potential columns and just render them based on content, but there are potentially hundreds of possible columns and that number can grow - typically there are only a dozen or so that should be displayed.  I can almost get there with something like below, but <apex:Repeat> won't take a param, and what I end up with is repeating ALL records on every row, rather than just the values for that record.  Any idea how I can tackle this?

<apex:outputPanel id="cPanel">
<table>
<tr>
<th>Contact</th>
<apex:Repeat value="{!taskSubjects}" var="subject">
<th><apex:outputText value="{!subject}"/></th>
</apex:Repeat>
</tr>
<apex:Repeat value="{!contacts}" var="contact">
<tr>
<td><apex:outputText value="{!contact.Name}"/></td>
<apex:Repeat value="{!cTasks}" var="ct">
<apex:param name="cid" value="{!ct.WhoId}"/>
<td><apex:outputText value="{!ct.ActivityDate}"/></td>
</apex:Repeat>
</tr>
</apex:Repeat>
</table>
</apex:outputPanel>

1. Click URL button on account, new VF page is presented with the correct related records
2. Click Previous/Next link, works fine, returning the pages of related records, BUT removes the params from the URL
3. Change pageSize in the selectList to something else, rerenders the navigation links and the pageBlockTable
4. Apparently causes my custom list controller to RESET and with the parameters removed, now I have a completely different set of records!

• If the opportunity has 1 line item, then my lineItem variable will contain a flat record and I can reference the field as lineItem.TemplateID__c
• If the opportunity has more than 1 line item it gets weird.  The first time through the loop, the lineItem variable is an array and I have to refer to the field as lineItem[0].TemplateID__c.  However the SECOND time through the loop it's flat!  And I can reference it as lineItem.TemplateID__c again.  So you can see the hack I inserted into the code.
  

strIdList = (list of opportunity Ids);
var result = sforce.connection.query("select o.Id, o.Name, o.CloseDate, o.HasOpportunityLineItem (select Id, PricebookEntryId, ServiceDate, TemplateID__c from OpportunityLineItems) from Opportunity o where o.Id in " + strIdList);
var oit = new sforce.QueryResultIterator(result);
while(oit.hasNext()) {
 var opp = oit.next();
 arrAllOpps[opp.Id] = opp;
}

...later processing each opportunity
var currentOpp = arrAllOpps[oppid];
//if (currentOpp.OpportunityLineItems) {
if (currentOpp.getBoolean('HasOpportunityLineItem')) {
 var lit = new sforce.QueryResultIterator(currentOpp.OpportunityLineItems);
 while(lit.hasNext()) {
  var lineItem = lit.next();
  var templateId = (lineItem.TemplateID__c == null) ? lineItem[0].TemplateID__c : lineItem.TemplateID__c;
  (...more operations on the line item)
 }
}

1. The IDE wanted to sync everything, which for some reason includes a lot of things that have not changed.  This is related to the synchronization issue I noted in my last post in this thread: Force.com IDE Synchronization Issue
2. I deselected everything and then selected only the one scontrol I needed to update.  Validation failed because I have several triggers I am working on in the sandbox which are nowhere near ready for production, and do not currently have test coverage.  Apparently it validates everything, even when not selected!

I use SoqlXplorer daily. I just allowed it to update to 1.80. The new version boots, asks for a login, and when I select one that is stored in a keychain, it hangs. I've tried rebooting it, and I've tried directing it to a different sfdc instance (in a sandbox), with no improvement.

I downloaded 1.70 from http://www.pocketsoap.com/osx/soqlx/, and it does not exhibit this problem.

My environment is a MacBook Air, 10.8.2. Simon, let me know if you would like any other data.

Thanks,

Bo

Every time I click the link in an email post reply notification, I get this message.

The link you clicked is requesting an operation that requires authentication, but the authentication failed.
There are five main reasons why this may happen:

1) The link you clicked on was not generated for you, but was intended only for someone else's use to perform an action on their account. If the other person pasted such a link into a message body or you were re-directed to such a link from another link you clicked on, the authentication will fail and you will arrive here instead.

2) The link was valid for you, but your authentication ticket has expired. If this is the case, hit the back button in your browser and refresh the page containing the link. You will then get a fresh ticket and when you click on the link again it will work.

3) Your browser session may have expired. If so, hit the back button in your browser, then refresh the page containing the link you clicked on. You will get a fresh ticket and if you click on the link again it will work.

4) Your browser may be set to not accept session cookies (or the cookie may have been deleted, or you may have been prompted and refused the cookie), in this case you should modify your browser settings to accept session cookies, and/or accept the session cookie if you are prompted, in order to use this site.

5) Your browser arrived at this location from someplace other than this site (an external link or site), or your browser or security software may be set to not send referrer information, in this case you should use the links on this site itself or verify that your browser or security software settings allow sending referrer information, in order to use this site.


Return to my original page ..

If I close this page, and click the link in the email again, it usually works fine.  It's getting rather annoying though.

Hi,

Our corporation instance of salesforce enterprise has been updated to winter 11, however when I click on my user name and go to system log, the old system log appears.

What do I need to do in order to enable the new one?

Thanks in advance!

Hi everyone,
I actually built a "simplified search" option for our sidebar, and our teams love it!  It is a combination of a visualforce page and javascript. Follow the 4 steps below to do the same.  Hope this helps!

1) Create a Visualforce page called "advancedsearch"
2) Use the following code as your page (Hint: for the "&sen=" portions in bold, these identify the objects you want to search.  For example, &sen=001 is an Account (click on the Accounts tab, and you will see those three numbers in the hyperlink).  My code below searches: Accounts, Opps, Contacts, Leads, and Campaigns

<apex:page showHeader="false" sidebar="false">
<apex:pageBlock >
<b>Enter search term: </b>
<apex:form >
<script>
function doSearch()
{
    var searchStr = document.getElementById('txtSearch').value;
    window.open('/_ui/common/search/client/ui/UnifiedSearchResults?sen=001&sen=003&sen=00Q&sen=006&sen=701&str=' + encodeURIComponent(searchStr), "_parent" );
}
</script>
<input type="text" id="txtSearch"/>
<input type="button" value="Go!" id="btnSearch" onclick="doSearch()"/>
</apex:form>
(<strong>NOTE:</strong> Only searches Accounts, Opps, Contacts, Leads, and Campaigns)
 </apex:pageBlock>
</apex:page>

3) Finally, go to setup > customize > home > home page components.  Create a new HTML area left sidebar component.  On the screen where you can enter in the HTML, make sure you select the checkbox "Show HTML" and then paste the following (this references your visualforce page and displays it in the sidebar):

<IFRAME height=150 src="/apex/advancedsearch?core.apexpages.devmode.url=1" frameBorder=0 width="100%"></IFRAME>

4) Add the custom component to your pagelayouts and test it out! 

I'm noticing issues with the new plugin related to syntax highlighting when editing VisualForce .page files. It intermittently stops highlight part of the text in the document. I haven't found a pattern when it occurs. 

It is also rendering squiggly yellow lines under my <apex:page> tag, and my first  <script> tag. Any ideas why? These are the first 2  items in my page.

<apex:page standardController="SR__c" 
	extensions="HSRControllerExtension" 
	showHeader="true" 
	sidebar="true" 
	tabStyle="SRt__c" 
	title="Entry Page" >
  
  <script type="text/javascript" src="{!URLFOR($Resource.jQuery142, 'js/jquery-1.4.2.min.js')}" />

Thanks,

Rich C. 

Hi How do I get around this error message...

Collection size 1,609 exceeds maximum size of 1,000.

public String cname{get; set;} public List<SelectOption> getnames() { List<SelectOption> options = new List<SelectOption>(); List<Contact> namelist = new List<Contact>(); namelist = [Select Id, Name FROM Contact where Recordtype.name='Company' Order by LastName,FirstName]; options.add(new SelectOption('--None--','--None--')); for (Integer j=0;j<namelist.size();j++) { options.add(new SelectOption(namelist[j].Name,namelist[j].Name)); } return options; }

<td> <apex:outputlabel value="Company Names" for="cnamed" /> <apex:selectList value="{!cname}" size="1" id="cnamed"> <apex:actionSupport event="onchange" reRender="newvalue" /> <apex:selectOptions value="{!names}"/> </apex:selectList> </td>

 Thank you

I am in the middle of debugging an Apex/Visualforce application, and the maintenance that just occurred this evening (1/22/10) just completely changed the behavior of the debug logs.  Two problems with this new behavior:

- My filter settings don't seem to be saving.  For instance, when I change my filter settings to "FINEST" in Apex Code and Save, those changes do not show up when I go to filter settings again.

-MOST IMPORTANT: the log line does not show the method name. Here is an example of the new format:

23:35:20.832|CODE_UNIT_FINISHED
23:35:20.833|CODE_UNIT_STARTED|[EXTERNAL]VForcePage
23:35:20.840|USER_DEBUG|[157,4]|DEBUG|***s.Id b4: a4yQ000000000DAIAY
23:35:20.840|DML_BEGIN|[159,3]|Op:Upsert|Type:BP_Stage_Rule__c|Rows:1

Notice - no method name in any of the debug lines.

I went to the Help and Training to find out if I am doing something wrong. It says the event identifier will log "any additional information logged with that event, such as the method name or the line and character number where the code was executed."  But they give an example pretty much like the one I copied and pasted in here -- no method name.

If anyone has any insight on how to get the method name to show or how to get the old debug log format to show, please be so kind as to respond.  If this is not possible, then salesforce just got 10 times harder to debug in my book.

Thanks for any help!

I've run into some issues after the summer 09 update changing the behavior of commandButton/commandLink rerenders and it behaves differently in Firefox vs. IE. I've got a pageBlockTable with one column containing a "Copy" commandLink and the next column containing an inputField. Clicking the Copy link will copy the value from the inputField on that row to all other objects in the list. The commandLink then refreshes the pageBlockTable only so the copied values are displayed to the user. This much works perfectly in both Firefox and IE.

However IE goes a step further. After refreshing the pageBlockTable and displaying the copied values correctly, it then refreshes the entire page. Problem is, this causes the original queries to re-fire and all the object values are returned to their original values and the user's "copy" is wiped out before their eyes. This second refresh does not happen in Firefox.

<apex:pageBlockTable id="avlist" value="{!accountVariables}" var="av">
<apex:column headerValue="Copy">
<apex:commandLink value="Copy" action="{!copyFieldValue}" status="accountcopy" rerender="avlist" rendered="{!IF(contains(av.Category__c, 'Account'), 'true', 'false')}">
<apex:param name="avarid" value="{!av.Account__c}"/>
<apex:actionSupport event="oncomplete" status="accountsuccess"/>
</apex:commandLink>
</apex:column>
<apex:column headerValue="{!av.FieldID__c} {!av.Variable_Master__r.Name}">

<apex:outputPanel id="editvalue" rendered="{!IF(AND(OR(av.Type__c='Image',contains(av.Type__c, 'Text')), contains(av.Category__c, 'Account')), 'true', 'false')}">
<apex:inputField value="{!av.Value__c}"/>
</apex:outputPanel>

</apex:column>
</apex:pageBlockTable>

Is anyone else encountering strange behavior with the actionStatus tag in their pages? I have a page that has several of these components and since the upgrade over the weekend they have become very finicky. Sometimes they work and sometimes they don't.

I am trying to build a simple example to reproduce but it has been difficult.

Thanks,

Jason