Gsyfuy

Why do some words that are not inflected have an umlaut?

Are there any other methods to apply to solving simultaneous equations?

"as much details as you can remember"

What is the motivation for a law requiring 2 parties to consent for recording a conversation

How to answer pointed "are you quitting" questioning when I don't want them to suspect

What to do when moving next to a bird sanctuary with a loosely-domesticated cat?

Does the shape of a die affect the probability of a number being rolled?

Why can Shazam fly?

Can you compress metal and what would be the consequences?

Resizing object distorts it (Illustrator CC 2018)

Is an up-to-date browser secure on an out-of-date OS?

Can a flute soloist sit?

Button changing it's text & action. Good or terrible?

Worn-tile Scrabble

What do hard-Brexiteers want with respect to the Irish border?

How are circuits which use complex ICs normally simulated?

Which Sci-Fi work first showed weapon of galactic-scale mass destruction?

If I score a critical hit on an 18 or higher, what are my chances of getting a critical hit if I roll 3d20?

How to obtain Confidence Intervals for a LASSO regression?

Have you ever entered Singapore using a different passport or name?

What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?

What does Linus Torvalds mean when he says that Git "never ever" tracks a file?

Landlord wants to switch my lease to a "Land contract" to "get back at the city"

How to notate time signature switching consistently every measure

How do I query on an extension attribute through the API?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I added an extension attribute to the Invoice class, and I want to be able to query the Invoice database data by my extension attribute.

My extension attribute (ExportedFlag) has these properties

• 
  entity_id The primary key


• 
  invoice_id The foreign key to the invoice table.


• 
  isExported A string value.

When an invoice gets created, it will not have a corresponding row in my extension attribute table. I want to be able to query the database for a list of invoices that don't have a value for the extension attribute, using the API (and then insert the value for that extension attribute).

Here's the code that I have right now that adds the extension attribute to invoices.

public function afterGetList

(

    MagentoSalesApiInvoiceRepositoryInterface $subject,

    MagentoSalesModelResourceModelOrderInvoiceCollection $searchResult

) {

    /** @var MagentoCatalogApiDataInvoiceInterface $invoice */

    foreach ($searchResult as $invoice) {

        $this->addExportedFlagToInvoice($invoice);

    }

    return $searchResult;

}  



private function addExportedFlagToInvoice(MagentoSalesApiDataInvoiceInterface $invoice)

{

    $extensionAttributes = $invoice->getExtensionAttributes();



    if (empty($extensionAttributes)) {

        $extensionAttributes = $this->invoiceExtensionFactory->create();

    }



    $exportedFlag = $this->exportedFlagProvider->getExportedFlag($invoice->getEntityId());

    $extensionAttributes->setExportedFlag($exportedFlag);

    $invoice->setExtensionAttributes($extensionAttributes);



    $exportedFlag = $extensionAttributes->getExportedFlag();

    $exportedFlag->setInvoiceId($invoice->getEntityId());

    $this->entityManager->save($exportedFlag);



    return $this;

}

The problem is that this code iterates through each invoice, and adds the extension attribute one-by-one. Furthermore, it retrieves all invoices, regardless of whether or not they have a value for the extension attribute (I don't want to retrieve values that have a row in the extension attributes table).

I want to be able to retrieve all invoices in a single query. Something like this

SELECT *

FROM sales_order_invoice

LEFT OUTER JOIN extensionAttribute

   ON sales_order_invoice.entity_id = extensionAttribute.invoice_id

WHERE extensionAttribute.isExported IS NULL

How can I do this within Magento?

magento2 database extension-attributes

share|improve this question

asked 11 mins ago

Ben RubinBen Rubin

1828

add a comment | 

0

I added an extension attribute to the Invoice class, and I want to be able to query the Invoice database data by my extension attribute.

My extension attribute (ExportedFlag) has these properties

• 
  entity_id The primary key


• 
  invoice_id The foreign key to the invoice table.


• 
  isExported A string value.

When an invoice gets created, it will not have a corresponding row in my extension attribute table. I want to be able to query the database for a list of invoices that don't have a value for the extension attribute, using the API (and then insert the value for that extension attribute).

Here's the code that I have right now that adds the extension attribute to invoices.

public function afterGetList

(

    MagentoSalesApiInvoiceRepositoryInterface $subject,

    MagentoSalesModelResourceModelOrderInvoiceCollection $searchResult

) {

    /** @var MagentoCatalogApiDataInvoiceInterface $invoice */

    foreach ($searchResult as $invoice) {

        $this->addExportedFlagToInvoice($invoice);

    }

    return $searchResult;

}  



private function addExportedFlagToInvoice(MagentoSalesApiDataInvoiceInterface $invoice)

{

    $extensionAttributes = $invoice->getExtensionAttributes();



    if (empty($extensionAttributes)) {

        $extensionAttributes = $this->invoiceExtensionFactory->create();

    }



    $exportedFlag = $this->exportedFlagProvider->getExportedFlag($invoice->getEntityId());

    $extensionAttributes->setExportedFlag($exportedFlag);

    $invoice->setExtensionAttributes($extensionAttributes);



    $exportedFlag = $extensionAttributes->getExportedFlag();

    $exportedFlag->setInvoiceId($invoice->getEntityId());

    $this->entityManager->save($exportedFlag);



    return $this;

}

The problem is that this code iterates through each invoice, and adds the extension attribute one-by-one. Furthermore, it retrieves all invoices, regardless of whether or not they have a value for the extension attribute (I don't want to retrieve values that have a row in the extension attributes table).

I want to be able to retrieve all invoices in a single query. Something like this

SELECT *

FROM sales_order_invoice

LEFT OUTER JOIN extensionAttribute

   ON sales_order_invoice.entity_id = extensionAttribute.invoice_id

WHERE extensionAttribute.isExported IS NULL

How can I do this within Magento?

magento2 database extension-attributes

share|improve this question

asked 11 mins ago

Ben RubinBen Rubin

1828

add a comment | 

I added an extension attribute to the Invoice class, and I want to be able to query the Invoice database data by my extension attribute.

My extension attribute (ExportedFlag) has these properties

• 
  entity_id The primary key


• 
  invoice_id The foreign key to the invoice table.


• 
  isExported A string value.

When an invoice gets created, it will not have a corresponding row in my extension attribute table. I want to be able to query the database for a list of invoices that don't have a value for the extension attribute, using the API (and then insert the value for that extension attribute).

Here's the code that I have right now that adds the extension attribute to invoices.

public function afterGetList

(

    MagentoSalesApiInvoiceRepositoryInterface $subject,

    MagentoSalesModelResourceModelOrderInvoiceCollection $searchResult

) {

    /** @var MagentoCatalogApiDataInvoiceInterface $invoice */

    foreach ($searchResult as $invoice) {

        $this->addExportedFlagToInvoice($invoice);

    }

    return $searchResult;

}  



private function addExportedFlagToInvoice(MagentoSalesApiDataInvoiceInterface $invoice)

{

    $extensionAttributes = $invoice->getExtensionAttributes();



    if (empty($extensionAttributes)) {

        $extensionAttributes = $this->invoiceExtensionFactory->create();

    }



    $exportedFlag = $this->exportedFlagProvider->getExportedFlag($invoice->getEntityId());

    $extensionAttributes->setExportedFlag($exportedFlag);

    $invoice->setExtensionAttributes($extensionAttributes);



    $exportedFlag = $extensionAttributes->getExportedFlag();

    $exportedFlag->setInvoiceId($invoice->getEntityId());

    $this->entityManager->save($exportedFlag);



    return $this;

}

The problem is that this code iterates through each invoice, and adds the extension attribute one-by-one. Furthermore, it retrieves all invoices, regardless of whether or not they have a value for the extension attribute (I don't want to retrieve values that have a row in the extension attributes table).

I want to be able to retrieve all invoices in a single query. Something like this

SELECT *

FROM sales_order_invoice

LEFT OUTER JOIN extensionAttribute

   ON sales_order_invoice.entity_id = extensionAttribute.invoice_id

WHERE extensionAttribute.isExported IS NULL

How can I do this within Magento?

magento2 database extension-attributes

share|improve this question

asked 11 mins ago

Ben RubinBen Rubin

1828

public function afterGetList

(

    MagentoSalesApiInvoiceRepositoryInterface $subject,

    MagentoSalesModelResourceModelOrderInvoiceCollection $searchResult

) {

    /** @var MagentoCatalogApiDataInvoiceInterface $invoice */

    foreach ($searchResult as $invoice) {

        $this->addExportedFlagToInvoice($invoice);

    }

    return $searchResult;

}  



private function addExportedFlagToInvoice(MagentoSalesApiDataInvoiceInterface $invoice)

{

    $extensionAttributes = $invoice->getExtensionAttributes();



    if (empty($extensionAttributes)) {

        $extensionAttributes = $this->invoiceExtensionFactory->create();

    }



    $exportedFlag = $this->exportedFlagProvider->getExportedFlag($invoice->getEntityId());

    $extensionAttributes->setExportedFlag($exportedFlag);

    $invoice->setExtensionAttributes($extensionAttributes);



    $exportedFlag = $extensionAttributes->getExportedFlag();

    $exportedFlag->setInvoiceId($invoice->getEntityId());

    $this->entityManager->save($exportedFlag);



    return $this;

}

SELECT *

FROM sales_order_invoice

LEFT OUTER JOIN extensionAttribute

   ON sales_order_invoice.entity_id = extensionAttribute.invoice_id

WHERE extensionAttribute.isExported IS NULL

share|improve this question

asked 11 mins ago

Ben RubinBen Rubin

1828

share|improve this question

asked 11 mins ago

Ben RubinBen Rubin

1828

asked 11 mins ago

Ben RubinBen Rubin

1828

asked 11 mins ago

Ben RubinBen Rubin

1828