If you don't like long read, then read next sentence. Essence of the article: If everybody in the world would lock himself at home for 2 weeks, or at let's say for one month, COVID-19 will die. But because of everybody says "I have the most important reason to go outside, or I will die" we see un...
Hello everybody,
today I want to describe how at code level you can add User defined fields in Acumatica to any entity. Sequence will be this:
In PXDataSource add attribute EnableAttributes. It may look like this:
<px:PXDataSource EnableAttributes="true" ID="ds"
2. For targe...
Hello everybody,
today I want to show to unit test, and I mean really unit test SOOrderEntry graph extnesion in Acumatica with XUnit.
In order to achieve it, you'll need following steps:
Create .Net Class library
Reference xUnit
Create public class that inherits from TestBase class
Add override...
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,
today I want to describe how to point to non standard port in My SQL for Acumatica.
Below goes fragment from my Web.config
<remove name="ProjectX" />
<add name="ProjectX" providerName="System.Data.SqlCli...
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...