How to delete a Record ?

Asked by Arfan on 2009-03-22

Hi to all,
How i can delete a record (Person record, admin data records) in iHRIS Qualify?
As i cant see any delete button in list.

Question information

Language:
English Edit question
Status:
Answered
For:
iHRIS Qualify Edit question
Assignee:
No assignee Edit question
Last query:
2009-03-25
Last reply:
2009-03-25
Arfan (arfanafzaal) said : #1

Hi
We add some data (specifically Administer Database: Certificate) and we dont need that records any more so how we can delete the Certificates which no longer we need.

Any one going to solve our problem?
We will be very thank full to u all.

Carl Leitner (litlfred) said : #2

For now there is no easy way to do this. In a future version we will add the ability to disable
the record.

Are you trying to delete just one or two records? Do you have many records to delete?

There are a few options, none of these is intended for an "in-use" server. Let us suppose
that there are just a few records. First, write down the id's of the Certificates that you wish
to remove. To get the id's go to "Administer Database" click on the certificate that you
wish to delete. In the URL you will see something like:
  qualify/lists?id=6902&type=certificate
Then the id is 6902

Now, from phpmyadmin, select the database you are using and select the 'record' table.
Now search where record.id=6902 and then delete the row.

Still in phpmyadmin, select the 'last_entry' table and select the rows where record.id = 6902 and
then delete them. Do the same for 'entry.'

You should of course make a backup of the database before you proceed.

Can you help with this problem?

Provide an answer of your own, or ask Arfan for more information if necessary.

To post a message you must log in.