Bryntum Support Forums

Hi,
We are adding validation for assignments through resourceassignment column.

used https://bryntum.com/products/gantt/docs/api/Gantt/column/ResourceAssignmentColumn#config-finalizeCellEdit for validating the assignments.
I want the currently added resources details . So used the "value" parameter to get the newly added assignments .

But the values shows all the assignments that were added

For example: if I add an employee say John to a task initially and come out of the resourceassignment editor. And again I go and add an employee namely Clara , then on the value parameter I get both John and Clara assignments records. I just want to get Clara's assignment on second time resource selection.

Is there any way to get only the currently selected records(Clara) and not along with the previously selected records?

Hey bhavisure,

Yes, there is a way, we have a parameter on finalizeCellEdit that has the old value of the field (you'll see it on the documentation as well, and from there, you can filter the difference to get only the new values. Would be something like this:

finalizeCellEdit : ({ oldValue, value }) => {
	// Get only the new values selected
	const newData = value.filter(value => !oldValue.some(oldItem => oldItem.id === value.id));
}

Hi Marico,
Got the newly assigned records. Thanks

But we are validating using a query it should wait till the response of the query.

  finalizeCellEdit: async item => {
            const { oldValue, value } = item;
            const newData = value.filter(
              value => !oldValue.some(oldItem => oldItem.id === value.id)
            );
            let idevent = item.record.id;
            let idresource = newData.map(o => o.resourceId);
            await ValidationFunc(idevent, idresource);
            debugger;
            if (
              ValidationResponse &&
              ValidationResponse.data == null
            ) {
              return false;
            } else if (
              ValidationResponse &&
              ValidationResponse.data.errorid == 1001
            ) {
              return true;
            }
          },

When the response of the query comes, by then return true false is not accepting .
Instead getting the below error

How to wait until the response of the query and then finalize the assignment ?
is there any way to add

async =  true

?

Hey bhavisure,

Are you able to share what your Gantt config looks like? I added a test column in our basic example with a fake timeout and it work just fine (without any errors), which version are you using??

{
            type             : 'resourceassignment',
            width            : 120,
            showAvatars      : true,
            finalizeCellEdit : async({ oldValue, value }) => {
            // Get only the new values selected
                const newData = value.filter(value => !oldValue.some(oldItem => oldItem.id === value.id));
                await new Promise(resolve => setTimeout(resolve, 3000));
                return true;
            }
        }

Also, there is a possible scenario when you don't have ValidationResponse in your code, it doesn't return either true or false.

Can you try returning false in same function

It worked as well because returning false means that there is an error in that cell edit action, as you'll see in the documentation

The edit will not complete until it returns false to mean the edit cannot be finished, or true to go ahead and complete.

In that case , I want to remove the assignment done in case the validation fails.
How can I remove the assignment ? is there something like

finalize(); 

?

Yes, there is, is not finalize, but you can cancel the editing like this

finalizeCellEdit : async({ oldValue, value, grid  }) => {
                // Get only the new values selected
                const newData = value.filter(value => !oldValue.some(oldItem => oldItem.id === value.id));
                // Do the validation
                await new Promise(() => setTimeout(() => {
                    grid.cancelEditing(true);
                }, 3000));
            }

https://bryntum.com/products/gantt/docs/api/Gantt/feature/CellEdit#function-cancelEditing

tried the same code you sent faced the below error

Im able to get the grid value and

startEditing()

function is also available

but

grid.cancelEditing

throws the above error

Why is it not working? any other way to procced with the logic ?

I tried it in our advanced react demo, And it works fine here. Could you please provide a runnable test case so we can debug it?