question Re: Combine two fields into one in Database view in Developer forum

Combine two fields into one in Database view

tsoct — Wed, 11 Jul 2018 10:24:32 GMT

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.

Re: Combine two fields into one in Database view

Dubz — Wed, 11 Jul 2018 10:31:21 GMT

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.

Re: Combine two fields into one in Database view

tsoct — Wed, 11 Jul 2018 10:39:00 GMT

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

Re: Combine two fields into one in Database view

Dubz — Wed, 11 Jul 2018 10:56:39 GMT

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?

Re: Combine two fields into one in Database view

tsoct — Wed, 11 Jul 2018 11:10:55 GMT

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

Thanks!!