Search criteria in Advanced Search
Answered
Hi,
How can we add attributes to the pre-populated lists for search criteria. The option enable for Search Criteria does not help.
Thanks.
Best answer
You are correct… the only attributes that come up, I believe, are those that are added to the affected items as columns… give that a try, add it to the affected item tab and then see if you can get it to work.
Ok so, there are only few base ids that make it to the Advanced Search pre-configured searchable attributes.
you can reverse the search if you don’t want to get particular attributes from the change but mainly on items:
Ex: SELECT change history.change number, item.number FROM Part WERE page two.attribute = ‘myCriteria’ and changehistory.change number = ‘12345’
