DB Query to fetch fields and reports which has 24 hour format

Sameer Patil shared this question 21 days ago
Answered

Hi Team,

We want to know fields present in system which are using 24 hour format, we set this format from column formatting.

I tried checking ReportFieldTemplate table but that does not have this information.

Also once we have field details we would also like to know the reports where they have been used.

YF Version : 8.0.8

Thank you in advanced.

Regards,

Sameer

Comments (4)

photo
1

Hi Sameer,

Thanks for reaching out. These details are stored in the ReportFieldParameter table.

Just take the first part of the Time Format option, in my following example, you can see this is "H:mm":

/0ea0d1ff04df754daa41ed5c4571cb18

Then search this value in the ParameterValue column, like so:

SELECT * FROM ReportFieldParameter WHERE ParameterValue = 'H:mm';

/4354ad9db140ff9ad6f21a702a4fab32

As you can see, in this same table you can also see which reports the field is being used in and what View said reports are built on via the ReportId and ViewId columns, respectively.

Hopefully this helps! Please let me know if you have any other questions.

Regards,

Mike

photo
1

Hi Sameer,

I just wanted to check in and see if you needed anything else here.

Regards,

Mike

photo
1

Hi Mike,

Thank you for the help.

Please close this.

Regards,

Sameer

photo
1

Hi Sameer,

You're welcome. Thanks for confirming. Will do!

Please don't hesitate to reach out with any other questions or concerns.

Regards,

Mike