Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Adding new columns in report not working

Artur Po_wiata
Tera Contributor

Hello, 

I'm during the report creation on Asset [aml_asset] table. 

When I want to add new columns, to be more specific:

Requested Line[+] -> Variables[+] -> Here I'm choosing specific Item -> List of fields 

 

From that list of fields I'm choosing 2 and want to add to the report columns, after click save button the columns disappeared

 Can you assist me with this problem ?

 

Best regards,

Artur Poswiata

1 ACCEPTED SOLUTION
7 REPLIES 7

@Artur Poświata 

You didn't mention in your original question that it's for database view

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar 

It's not database view. 

I assume the issue it's also occur in other views. 

"In all current releases it is not possible to report on variables through a database view. The only option is to report against the table that contains the variables directly."

jmcagod
Kilo Guru

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0640041

I am not sure what they meant by new UI, but when I tried to create one from scratch it is working (new UI) and then updating it (new UI) - sometimes it shows, sometimes it doesnt. Weird bug. Im using San Diego release

 

Edit: It is working, just taking time to load (ie. max 1 min)