Skip to main content
Answer

How can I programmatically fill an entity Attribute?

  • January 27, 2022
  • 5 replies
  • 356 views
darylbowman
Captain II
Forum|alt.badge.img+15

I am familiar with programmatically CRUDing records, but how can I use this functionality with Attributes?

 

CRCaseMaint caseGraph = PXGraph.CreateInstance<CRCaseMaint>();
CRCase newCase = caseGraph.Case.Insert(new CRCase());
caseGraph.Case.SetValueExt<CRCase.caseClassID>(newCase, caseClassID);
caseGraph.Case.SetValueExt<CRCase.customerID>(newCase, bAccount.BAccountID);
caseGraph.Case.SetValueExt<CRCase.subject>(newCase, subject);
newCase = caseGraph.Case.Update(newCase);
caseGraph.Actions.PressSave();

 

Best answer by rjean09

Try something like this: 

// iterate attributes on case to set values

var answers = caseGraph.Answers.Select();

using (var ts = new PXTransactionScope())
{

	foreach (CSAnswers att in answers)
	{
		if (att.AttributeID == "MYATTRIB")
		{
			att.Value = "My attribute value";
		}
	}

	caseGraph.Answers.Cache.Update(answers);
	caseGraph.Task.Cache.Update(caseGraph.Case);
	caseGraph.Actions.PressSave();
	ts.Complete();
}

 

Daryl ⚡Freelance Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman

    5 replies

    D
    Captain II
    Forum|alt.badge.img+7
    • Django
    • Captain II
    • January 27, 2022

    Are you asking about getting/setting the value of an attribute associated with the Case record? 

    darylbowman
    Captain II
    Forum|alt.badge.img+15
    • darylbowman
    • Author
    • January 27, 2022

    Yes, exactly

    Daryl ⚡Freelance Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
    R
    Semi-Pro III
    Forum|alt.badge.img+1
    • rjean09
    • Semi-Pro III
    • Answer
    • January 27, 2022

    Try something like this: 

    // iterate attributes on case to set values

    var answers = caseGraph.Answers.Select();

    using (var ts = new PXTransactionScope())
    {

    	foreach (CSAnswers att in answers)
    	{
    		if (att.AttributeID == "MYATTRIB")
    		{
    			att.Value = "My attribute value";
    		}
    	}

    	caseGraph.Answers.Cache.Update(answers);
    	caseGraph.Task.Cache.Update(caseGraph.Case);
    	caseGraph.Actions.PressSave();
    	ts.Complete();
    }

     

    Chris Hackett
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • January 28, 2022

    Hi @Deetz  Below code might help you for your requirement.

     

       CRCaseMaint caseGraph = PXGraph.CreateInstance<CRCaseMaint>();
                    using (var ts = new PXTransactionScope())
                    {
                        CSAnswers objMyAttAns = caseGraph.Answers.Select().FirstTableItems.ToList().Where(x => x.AttributeID == "MYATTRIB" && x.RefNoteID == CaseRecordnoteID);

                        if (objMyAttAns != null)
                        {
                            objMyAttAns.Value = "My attribute value";
                            caseGraph.Answers.Cache.Update(objMyAttAns);
                            caseGraph.Actions.PressSave();
                        }
                    }

     

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    Chris Hackett
    R
    Semi-Pro III
    Forum|alt.badge.img+1
    • rjean09
    • Semi-Pro III
    • January 28, 2022

    FYI, if you want to get the value of an attribute from a DAC field using PXSelector, take a look at this blog post: 

    https://blog.zaletskyy.com/post/2020/08/17/post100

    darylbowman
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved