Combine two fields into one in Database view

[tsoct]

Hi All,

I have created a view containing two tables Problem and Incident. Both tables contain a number field, so database view also shows two fields having the same label called 'Number'.

Is it possible to combine two fields into one field? 

ex: inc_number + prb_number -->> incprb_number

**I know I can get both fields combined in parent table =TASK. But running the report using TASK table is not giving me the custom fields that I have created in Incident & problem table. Hence I need to create a view for this. 

[Dubz]

The number field is extended from task so it should only show as 1 field, have you created custom fields on INC and PRB called inc_number and prb_number?

You won't be able to combine fields in a database view but, if you have created custom number fields, you could copy back the value of those fields to task.number and then use that field in your report.

[tsoct]

Hmm. I did not create any field for the number but this is what I see from the table of the view

[Dubz · Accepted solution]

Ah ok the database view must create those fields to avoid ambiguity.

I just tried running a report on task and i have access to all the custom field i have on incident and problem. There is a list of fields in red with the field name and the table in brackets after it eg 'service affecting (problem)', are your custom field not available there?

[tsoct]

I have the impression that i wont be able to see custom fields in TASK table.. but now I see all... 

Thanks!!