finally I found out how to catch all queries to MySQL server, generated by Acumatica. Well, in context of My SQL as usually people work more with MYOB, but under the hood MYOB is Acumatica.
Typical schema of Acumatica <-> MySQL connection looks like this:
In order to get generated MySQL qu...
Hello everybody,
quick post on how to install MySQL proxy. You may be puzzled why it is needed? Because MySQL proxy allows you to track all generated SQL by MySQL. As of now, you can catch generated SQL for SQL server with SQL Server Request Profiler. But in order to achieve it for MySQL, you'll...
Hello everybody,
Recnetly I had a need to create PXProjection and wanted to use in declaration of it not SelectJoin, but FBQL SelectFrom with combination of InnerJoin. Finally I've got something like this:
[PXProjection(typeof(SelectFrom<SOOrder>.InnerJoin<SOLine>.On<SOOrder.orderT...
Hello everybody,
today I want to write a few words about how to use PXDBscalar in connection with PXProjection and is it possible at all.
First of all want to say that it's defientely a possiblity. Take a look on this sample of implementation:
[Serializable]
[PXProjection(typeof(Select2<FABoo...
Hello everybody,
today I want to write a newer post about how to give an opportunity to user go to some link from Acumatica. As I've mentioned in https://blog.zaletskyy.com/types-of-redirects-in-acumatica, redirections are implemented as exception. Let consider next simple code, by which you can...
Hello everybody,
today I want to share idea on how to get getting Combo-box values set for REST API.
As usually values of comboboxes values are just hardcoded in web api calls, but sometimes it may be necessary to load them from Rest API, for example for cases if you want to target multiplve...
Hello everybody,
today I want to write a few words about method CreatePaymentProc in graph SOOrderEntry.
Among different features of this method, want to describe that it have for some reason out parameter! Take a look on it's declaration:
public virtual void CreatePaymentProc(SOOr...
Hello everybody,
today I want to leave a short note about Acumatica Architecture. Take a look on this picture:
As you can see from the schema business logic controllers is kind of single source of truth. Acumatica doesn't have dependencies between UI and Web services. Also it means, if you hide...
Hello everybody,
today I want to leave short note on issue with CROpportunity DAC class.
For quite a few times I've noticed that someone adds field to CROpportunity, but later notices that field is lost either on moment of loading from database, or lost during persisting record to data...
Hello everybody,
today I want to write a few words on how to modify behavior of buttons Add task, Add event, Add email, Add activity, ..., Add work item of Business Accounts page.
The main issue of chaning it is in the fact, that it is not just ordinary buttons, but separate class, which has inje...