Report Template

[Amirtharaj_K]

Hi Guys,

      I am following the steps like in the link below, but I am not sure how to work on point 12.

12. Use the Criteria tab to specify any additional criteria that should automatically be applied. For more information, see Query Builder Criteria.

The Sort tab does not affect how the search results are sorted.

https://support.ptc.com/help/windchill/plus/r12.0.2.0/en/index.html#page/Windchill_Help_Center/LclSrchAdvancedSearchExampleReportTemplate.html

Regards,

Aj

[Fadel]

In the below example first I have created a report to show parts , in the second part I have used constraint tab sub select

on table WTUser to have only parts created by wcadmin

I hope this answers your question

matrix-path.mp4

Video Player is loading.

Play Video

Play

Mute

Current Time 0:00

/

Duration 0:00

Loaded: 0%

0:00

Stream Type LIVE

Seek to live, currently behind liveLIVE

Remaining Time -0:00

1x

Playback Rate

Chapters

• Chapters

Descriptions

• descriptions off, selected

Captions

• captions settings, opens captions settings dialog
• captions off, selected

Audio Track

Picture-in-PictureFullscreen

This is a modal window.

Beginning of dialog window. Escape will cancel and close the window.

Text

ColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-Transparent

Background

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparent

Window

ColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque

Font Size

50%75%100%125%150%175%200%300%400%

Text Edge Style

NoneRaisedDepressedUniformDropshadow

Font Family

Proportional Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall Caps

Reset restore all settings to the default valuesDone

Close Modal Dialog

End of dialog window.

Close Modal Dialog

This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.

[HelesicPetr]

Hi @Amirtharaj_K 

The paragraph 12 says that you can set additional criteria internally in the Report template on the Criteria tab in the query builder editor and users can not change that criteria.

Also the last sentence of the paragraph 12 says that the Sort tab in the queribulder editor does not take effect in the advanced search result table. 

Is it more clear?

PetrH

[Amirtharaj_K]

Thanks for the reply @Fadel @HelesicPetr

@HelesicPetr Thanks for the more details.

@Fadel  can we use this report template in Advanced Search,

 Regards,

Aj

[Marco_Tosin]

How to ensure Report Templates and Reports are available for use in Advanced Search

[Fadel]

@Amirtharaj_K  yep , see https://www.ptc.com/en/support/article/CS245106

[Amirtharaj_K]

@Fadel  as you said I enabled the available for use in Advanced Search i can't see the like the below one.

Refer to the first conversation link. 

Regards,

Aj

 

[HelesicPetr · Accepted solution]

Hi @Amirtharaj_K 

In the query builder you have to check that the report can be used in the advanced search 

and also you need to specify what type of object the report can be used in the table and joins

PetrH