Hello everybody,
today I want to describe following use case. Quite often it is needed to persist to database one or another DAC class, which is filled by some data.
As usually I see people do this via hard coding of DAC class inside of the Graph. But today I want to share with you a way of...
Hello everybody,
today I want to leave a short snippet on how to override methods in CreateMatrixItemsImpl graph extension. Below goes code snippet you can use for this purpose:
public class CreateMatrixItemsImplExt : PXGraphExtension<CreateMatrixItems.CreateMat...
Hello everybody,
recently one of the colleagues asked me how to make selector from Attributes values. Also that request seem trivial, but still took some time, especially with usage of FBQL query to build.
Below goes template you may use if you'll need some kind of selector for attributes b...
Hello everybody,
I want to leave a quick hint on how to use Const values in Acumatica for FBQL. Below goes sample:
public class someBranch : PX.Data.BQL.BqlInt.Constant<someBranch>
{
public someBranch() : base(48)
...
today I want to share with you interesting use case which stolen one night of sleep from me, as well as from one of my collegues.
We had very trivial case. Or at least we thought it is trivial. In Acumatica we had something like this:
#region UsrCardTheme
[PXDBString(256)]
[PXUIField(D...
Hello everybody,
today I want to write a few words on how to override persist method of Acumatica properly. When I say properly I mean not save just some fragment of data, but use transaction like approach.
In other words how to achieve all or noghint during persisting.
Quite often I see templat...
Hello everybody,
today I want to share with you my guess regarding why Acumatica can't restore snapshot bigger then 2 Gb. As far as I see at database level, all files are going into table UploadFileRevision. If to look into structure of this table, you'll find that it has column data, which...
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...