Deleting Values in Qualified Table

[Former Member]

We need to delete values in a QT.

Some of them are already associated with a record in a main table and can not be deleted from teh QT directly.

Uisng teh Data Manager, we can select the records, then the values in the QT, right click and choose remove to delete the QT value for that particular record.

Instead of doing one by one, Is there a way to do the same for a large number of records?

Thanks

Nicolas

[Former Member · Accepted solution]

Hi Nicolas,

If u want to delete all values in ur Qualified Table then simple work around will be Delete that Qualified Table itself from Console & create it again.

If u want to delete some values from QT then remove Qualified lookup table field from Main Table....in console

This will remove all links with main table but all values in Qualified Table will remain as it is.

Then u can delete selected values from it (Which u want to delete)

Thanks,

Maheshwari

[Former Member · Accepted solution]

Hi Nicolas,

You can use import manager to delete the values for the qualified field and also to the qualified table or you can use APIs also.

Best Regards,

Silpa

[Former Member · Accepted solution]

Do you have an example of a program using java API to delete values in a QT?

Thanks

[Former Member · Accepted solution]

Hello Nicolas,

Here are some of the blogs that talk about deleting mass records from qualified table. I do not have the sample code but Import solutions worked for me.

Please do update your blog so that all of us can learn.

Thanks

Shai

We need to delete values in a QT.

Some of them are already associated with a record in a main table and can not be deleted from teh QT directly.

Uisng teh Data Manager, we can select the records, then the values in the QT, right click and choose remove to delete the QT value for that particular record.

Instead of doing one by one, Is there a way to do the same for a large number of records?

Thanks

Nicolas

[Former Member · Accepted solution]

thanks

deleting the field from the main table solved my problem with deleting values from the QT

[Former Member]

Hi Nicolas,

for deleting QT values follow the below procedure:

1)in data manager record mode,search for records based on the qualified table values(qualified table available values can be found inside the QT).

2)After finding all the records,select all and in qualified display,delete/remove them.

3)Now u can go to the QT and remove the NQ values. Now no QT value assigned to any record.

If still u face any issue,pls feel free to contact.

regards,

bis