Combining two tables without similarity

[amalina]

Hi,

Is it possible to create a view using two tables without similar column.

I need to combine task & new_call table to get a full list of My request.

Any idea?

Thanks in advance for the help.

[Shiva Thomas]

Hi Amalina,

I installed the ServiceDesk Call plugin on my Dev instance, and I confirm that the new_call table is not a child of the task table. This came as a surprise to me.

I also noticed that by default, you can't create an active new call. The field "Call type" is mandatory and on Save/Update it creates directly the INC/CHG/PRB/... depending of the Call type. This is why there is no "Assigned to" or "Assignement group" by default. Those are to be managed in the sub-sequent task. So by default you can't have an assigned call that is a work in progress.

Did you create custom fields for Assignation? In that case, may I suggest that you create a new "u_call" custom table from the task table, and to manually duplicate the form and Business Rules used by the new_call table. This would allow you to use the Calls as you seem to intend to.

[amalina]

yeah..we have a custom field assignment group but no assign to field.

creating a new custom table might be the way to go here.

Thanks for your time Shiva..really appreciate it.

[Shiva Thomas]

You're welcome.

Obviously ServiceNow did not intend Calls to be managed as tasks, but only to be transient artifact.

My advice: As soon as you want to use a table with a different business logic than the one expected by ServiceNow, duplicate the relevant info and use your own table (or extended table). This is much better than trying to swim against the "SNow Flow".

[randrews]

doesn't new call extend task?   if you are using any version after eureka i believe it was.. the new call module actually is PART of the task table so there should be no need for a join...

if you are on pre eureka version.. hmm wow that is a major pain.. you will probrably need to work with service now and figure out how to get on the oob new call system that extends task

to see if in your instance new call extends task.. go to system definition tables and find new call... add the column extends table and see if task is there.

[Shiva Thomas]

Hi Raymond,

I checked on my Istanbul Dev instance, and the new_call table is at the root level. It doesn't extend the task table.