Service Manager / Service Center Practitioners Forum
cancel

Remove Dupicates entry in table

SESHAC
Respected Contributor.

Remove Dupicates entry in table

Hi,

 

Need to Remove duplicates entry in table using javascript

 

For Example

*************

 

I have below id in Todo table by using javascript i need to remove duplicates and remain one value like this i have more than 3000 records got duplicate , Please help me

 

IM10001

IM10001

IM10001

IM10001

IM10002

IM10002

IM10002

IM10004

IM10004

IM10004

 

Output

IM10001

IM10002

IM10004

 

 

 

 

5 REPLIES
John Stagaman
Acclaimed Contributor.

Re: Remove Dupicates entry in table

It might be easier to reset the ToDo table (removing all entries) then run the apm.upgrade.todo  application from the command line. It will create new ToDo records for all active records.

----------------------------------------------------
Kudos - what, where, how, and why
Want Good Answers? Ask Good Questions...
SESHAC
Respected Contributor.

Re: Remove Dupicates entry in table

Hi John

From the command line i entered apm.upgrade.todo

It was giving error "Unrecognized command. Reenter."

Please suggest me where exactly we need to do
Highlighted
Audrey H.
Acclaimed Contributor.

Re: Remove Dupicates entry in table

Hi,

 

I would assume, since it is an application you should probably enter *aapm.upgrade.todo

SESHAC
Respected Contributor.

Re: Remove Dupicates entry in table

How it works *aapm.upgrade.todo ?
Piku
Acclaimed Contributor.

Re: Remove Dupicates entry in table

Hi,

It is sm feature that you can call many utility from command line but you have to tell sm that you are calling RAD in this case.
*a tells sm that you want RAD having name 'aapm.upgrade.todo '

If you want to open a file then use ‘ *f ‘ like type *fcm3r will open cm3r table and direct you to search engine as per document engine.

*q<query name> query.stored Runs a stored query.
*s<script name> script.execute Runs the specified script.

#<command name> #li display list of all commands that start with “li”


hth

____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.