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,
today I want to leave a short note on Execution Timeout Expired. In case if you face it on your local dev environment, then consider adding following key in your web.config:
<add name="PXSqlDatabaseProvider" type="PX.Data.PXSqlDatabaseProvider,
PX.Data" ... queryTimeout="100"...
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,
today I want to leave a short note on how to connect Acumatica with MySql. Recently for me was needed to organize connection between API project which send requests to Acumatica and MySql database. In codebase I've seen following line:
using MySqlX.XDevAPI.Relational;...
Hello everybody.
Today I want to leave a short note on include section of SQL queries. Imagine that you see SQL Query similar to this:
CREATE NONCLUSTERED INDEX [tt_CSAttributeGroup] ON [dbo].[CSAttributeGroup] ([CompanyID], [EntityClassID], [EntityTy...
Hello everybody,
Today I want to leave a short snapshot which addresses following issue.
One of my friends got table in Acumatica created, but for some reason at DB level he decided not to set there any field as part of Primary key. He had IsKey attributes set only at DAC class of Acumatica...
Hi everybody,
It happened. I've got COVID-19 myself. As well as my wife. Very unpleasant feelings honestly speaking.
On the day 1 of symptoms I've got those:
a. Temperature ( ~38 )
b. Headache
c. Weakness
Now I have one more concern about my parents. I'm worried if they got or not got COVID...
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)
...