Method Community

So am importing our database into method. Have some fields in our database that are the same field name as methods, one of them being suffix. When I go to import our table and choose to map my suffix field to existing field, suffix is not in the drop down menu to choose from field names. Am I missing something here? I checked to make sure suffix ...

Hi Method, I'm having trouble getting the "view" button in the estimate grid to populate data into the PDF template. is there a bottun I can copy that will get the record ID, filter for an individual and generate the report into the template. I am pretty sure I am using all the right fields , but non of the data wants to appear.

Hi Method, I am having a few issues with the save buttons on Edit Profile screens. I need to add several fields that are not on the default "ContactsPortal_EditProfile screen. I have most of it working properly. However, (1) the screen creates a new contact, syncs it into QB but doesn't update the original. (2) it does not sync/update ...

I deleted the screen and started over. That fixed the problem. thanks.

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?