Hello everybody,
today I want to share one line of code for Acuminator for error message:
PX1016 A DAC extension must include the public static IsActive method with the bool return type. Extensions which are constantly active reduce performance. Suppress the error if you need the DAC extens...
Hello everybody,
recently for me it was needed to find out all key fields of DAC class. Code below does this:
public List<string> GetKeyFieldsOfDAC(Type dacClass)
{
var result = new List<string>();
&nb...
Hello everybody,
today I want to leave a short note on how to avoid Copy/paste with help of custom attributes.
Imagine following scenario. You have some set of duplicated code, which you need to apply at FieldSelecting . One of the ways of achieving this can be creation of some class a...
Hello everybody,
today I want to leave a note on usage of RowPersisting event.
Quite often I see situations, when RowPersisting is used for making additional insertions to database. Also quite often I see cases when some additional inserts being performed to database.
I want to warn against...
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...