Method Community

Thanks, David, but actually I did understand what you are saying. I know that every database I have used has some way of limiting queries for the purposes of paging through the results. Pagination is logically separate from a set of filtering criteria in that it is an additional criteria on top of the filtering. MySQL does that with the LIMIT ...

Hi gbisaga, I think you misunderstood my response....using a date field was just an example. You can filter by any combination of fields in the table. If it is there you can add it to the where clause with a conditon. So if you had a string field, a numeric field, and a datefield you can build something like. myField1 = ...

Hi Dave, thanks for your response. It's not that I specifically want to use the LIMIT clause, but rather that I want to limit the number of rows that comes back. The result could return tens of thousands of rows, which is a lot of data to process at once. I can't really use a date clause like you suggest because I am syncing with past ...

Thanks!  Will do. April

Hi gbisaga, We don't run MySQL we run SqlServer...so in a word no....since limit is not a part of standard sql. However what you can do to limit data is use the where clause to filter data. For example I might have a table with a date field and only want orders from today onwards. So I might pass in to the where clause something iike ...

Hi, I am trying to call MethodAPISelect_XMLV2 but I don't want all the records because that would be quite a lot. Is there any way I can limit the results I get, similar to a MySQL "limit" clause?

Hi tom, The function behaves the same for both leads and customers so I'm not sure why the user didn't receive an email notification. Does anyone from your organization receive Method emails? If not then I would recommend you check your email server settings/contact your hosting provider. I just created a test opportunity and selected ...

Sales created an opportunity and created an activity for another employee to visit customer. The opportunity did not appear for the activity assignee nor was an email generated (even though the email box was checked. Does an opportunity/lead to be converted to a customer for the normal activity assignment to work or was did we do something ...

Hi April, We found the issue.  On your "Last Modified Date" field, you are using "(GMT -7)" to override the default time.  This is what is causing the error in Method.  I would suggest setting the time another way, perhaps using the current time and using a math calculation to alter the time.  Method will ...

We received the following question from Zirah by email: [quote]How do you change the tab order of the fields? I moved Full Name to appear after first and last, but the tab does not match the new order.[/quote] Hi Zirah, You'll have to edit the screen, then click on the Advanced button, and get to step 3 of 5 to edit your tab ...