Method Community

Thanks, Ben! That clears it up. Appreciated.

We're trying to minimize the size of our Method database in an effort to speed things up a bit. After several years working with QB & Method, our QB file & Method DB have grown QUITE large. My question is related to this post made just moments ago in the general forum.  Based on the concept laid out in that post, my question ...

What does this mean: Maintain for the past X days? Is this audit trail transaction history, or transactions in general? Our file has grown to a very large size over the years, with a full synchronization taking up to 30 minutes at a time, and we're looking to make things more efficient.  For example, if I set the transaction history ...

To clarify: Why would you limit us to one result, severly impacting potential functionality that would broadly increase our ability to provide useful grid data? Not: Why will a function not complete when it results in error.

Not possible, okay, but WHY?

We are attempting to build a query for an SQL override grid field that could return more than one result, i.e. query Item FullName to determine associated open sales order line items, returning the sales order refnumber. Problem is, all we can do currently is display the most recent, or MAX sales order refnumber. What I would like to do is to ...

To be clear, when using the export API through the CRM control panel, it is exported as 2015-Jan-01 HH:MM:SS. Only thing that would be nice to see is if we could change it to something more along the lines of 2015-01-01 HH:MM:SS.

Thanks, Audisho. Will await your reply.

Guys, When exporting data, any column that is of type DATE exports like so... Jan-01-2015. Every time we need to parse through the data to convert to proper DATETIME or TIMESTAMP format to do anything useful with it. Can you either offer a toggle-switch that allows for properly-formatted date/time fields or simply switch to a more usable format ...

Now we're talking. Thanks Audisho! This, I can use  FW