[SOLVED]Unable to edit/view unresolved object on Process

Jhstephenson

I have a Notes BO that I want to find some specific text in and if found assign a NoteType to those records.

So, I have a process that does the following:

FIND mfNoteTypes WHERE mfNoteTypes.NoteType='REQUEST FOR DISCOVERY'

FIND ClientNotes WHERE (ClientNotes.Note CONTAINS 'requested discovery' OR ClientNotes.Note CONTAINS 'request discovery') AND ClientNotes.NoteType IS UNDEFINED AND ClientNotes.parentClientMaster IS DEFINED
 INSERT ThismfNoteTypes IN ClientNotes.NoteType

When I run this I get a "Unable to edit/view unresolved object" error.

The log doesn't really show me anything, just the error.

What do I have wrong in this?

PointsWell

Just quickly scanning so more questions than answers:

ClientNotes.NoteType: it is One ClientNotes has One Notes Type? If so I'm not sure INSERT will work, it is for lists (i.e. One Client Notes has Many Notes Types), generally on peer single relationships it is sufficient to say ClientNotes.NoteType=mfNoteTypes

Have you already got mfNotesTypes Business Objects in context? If not then you shouldn't need ThismfNotesTypes - I've had issues with This and That where there is only one BO in context.

Is the FIND returning any business objects? And is the second query returning items?

JonP

You're treating ClientNotes.NoteType like a multiple reference BO, which I think is the problem. It's single-reference, right? Try:

ClientNotes.NoteType = ThismfNoteTypes

BenHayat

JonP wrote
ThismfNoteTypes

Jon, you shouldn't be using foul language in your code... :lol:

Jhstephenson

I have tried it with both the INSERT (why I used that I don't know) and also just a normal assignment:

ClientNotes.NoteType=ThismfNoteType

The result is the same either way.

The odd thing is that this process actually worked before we moved to 8.2. But I hadn't run it for several months, so I am just assuming I screwed something up in it, when I added the last filter for the parent_ClientMaster.

Jhstephenson

PointsWell,

The FIND on the mfNoteType is finding the correct record. I have verified that.

Also, as far as the INSERT or just assigning the mfNoteType, I really don't even think that it is getting to the point where it tried to do it. It seems like the error is hitting when I try to find all of the ClientNotes that match the criteria.

johntalbott

Jhstephenson wrote

I have a Notes BO that I want to find some specific text in and if found assign a NoteType to those records.

So, I have a process that does the following:

FIND mfNoteTypes WHERE mfNoteTypes.NoteType='REQUEST FOR DISCOVERY'

FIND ClientNotes WHERE (ClientNotes.Note CONTAINS 'requested discovery' OR ClientNotes.Note CONTAINS 'request discovery') AND ClientNotes.NoteType IS UNDEFINED AND ClientNotes.parentClientMaster IS DEFINED
 INSERT ThismfNoteTypes IN ClientNotes.NoteType

When I run this I get a "Unable to edit/view unresolved object" error.

The log doesn't really show me anything, just the error.

What do I have wrong in this?

I assume "FIND ClientNotes WHERE ..." is returning a number of instances, so there isn't a specific object in context to then apply the INSERT.

The only way I've ever been able to get this type of thing to work is to user either:

IN BATCHES OF 1
Use sub-process (to get the effect of a For Each loop)

https://forum.awareim.com/d/8774/8&hilit=update+multiple+rows#p38846

johntalbott

Ok .. ignore what I just said. What I didn't think worked previously seems to be working now.

Jhstephenson

I figured out the issue. It is with the ...AND ClientNotes.NoteType IS UNDEFINED...

Turns out that when the data for this BO was imported MySQL objected if there was not an actual NoteType assigned to each record, even if there wasn't one in the original data. So, we had to create a blank NoteType.

Which meant that every record had a NoteType. So it was doing what it was told to, only find the records where the NoteType was undefined, which there were not any of.

Sorry for the dumb question.

PointsWell

Jhstephenson wrote
Sorry for the dumb question.

I have plenty of those. A lot of them even make it onto here.

BenHayat

Jim, if this issue is resolved, please prefix the title of your original post with [SOLVED].