New Topic
CommunityTopicQuestionAdministration
Properties
Category Administration
Product Version 8.0

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

Sameer Patil shared this question 3 years 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

1 The same question

Replies (4)

photo
1
Mike Sheehan ● 3 years ago

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

Reply
photo
1
Mike Sheehan ● 3 years ago

Hi Sameer,

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

Regards,

Mike

Reply
photo
1
Sameer Patil ● 3 years ago

Hi Mike,

Thank you for the help.

Please close this.

Regards,

Sameer

Reply
photo
1
Mike Sheehan ● 3 years ago

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

Reply
Leave a Comment
 
Attach a file