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)
...
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 share with you how it's possible to call some methods of Acumatica, which are not public, and which you don't want to copy/paste completely into your source code. In that case reflection will save you. Consider calling of InsertSOAdjustments method of graph SOOrde...
Hello everybody,
today I want to tell you a story, that swallowed quite big amount of time of whole team.
Recently we've got seemingly easy to fulfil requirement:
Add button to the grid
Inside of the button fullfil
Persist
Call to db with modifications
Persist one more time
Leave...