Skip to Content

Issue with QueryByEmelents in Massive Data Run (MDR)

Dear Expert,

I faced with an issue with developing MDR.

Let me explain our scenario.

We need to do a massive update for all customers, but we need to copy a value of each ticket and then paste it in a field of related customer of each ticket.

So with MDR, I need to create a query to read all tickets and then go to related customer of ticket and copy a value of a field in Ticket BO to Customer BO.

But the problem is that in ServiceRequest BO, we hav just QueryByElement and MDR is not accepting QueryByElement

as an alternative, I tried to read all customers, and then go to the Ticket of Customer, but there is no association from Customer to Ticket

I really blocked...

Can anyone please help me about this?

Many thanks
Sepide

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 25, 2018 at 03:04 AM

    Dear Sepide,

    Custom MDR can be created only on Custom BOs and for that you need to create an action and query for that.

    One approach you can try is to create a custom MDR and via the MDR action, you can execute QueryByElements on ServiceRequest BO.

    Best Regards

    Anil

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Anil,

      Thanks a lot for your response,
      Actually I have created my custom BO, but I do not know why I see an error message regarding to QueryByElements,

      But now I do not have any problem with MDR and is solved

      Thanks for your reply and help

      Sepide