Hello,
today I want to leave a post about code quality regarding of PXStringListAttribute. If to look in older versions of Acumatica manuals ( for example T200 manual ) you can see something like this:
public class Something : IBqlTable
{
[PXStringLi...
Hello everybody,
today I want to share one workaround, which I sometime use as temporary measure for migration projects. Imagine, that you've added reference to your bin folder of one of your old customizations. Then you build it, and you've got this error message:
Server Error in '/xxx' Applicat...
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 u...
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.SqlCl...
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<SOOrd...
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...