Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

serial number field in reporting not showing up without quantity

wahid3
Tera Contributor

‎06-12-2020 11:57 AM

I am trying to create a report on 'Asset Covered' table combining asset and its related CI info. Without adding asset.quantity, serial number columns does not show any serial number. However I do not want to show quantity in the report. I know there is an ACL on quantity which basically says if the quantity is less than 1, do not show serial, however in our case quantity is 1 and it does not show any serial number when quantity field is not added as a column. Thanks in advance.

find_real_file.png

Labels:
Preview file
209 KB
0 Helpfuls
  • 2,442 Views
5 REPLIES 5

wahid3
Tera Contributor
In response to Brad Bowman

‎06-15-2020 08:34 AM

Thanks. I will discuss with my admin to open a HI ticket. In the mean time I will try using database views to create similar report connecting contract, asset and related CI and model, and see if it causes any issues. Thanks again for your input.

0 Helpfuls