REPEAT REGION FILTERS BY PARAMETER VALUE

[BR84]

Dear All,

I'd like to filter 2d repeat region table for family table by value of parameter ,for an ex.

• If certain parameter has a value of Y then row should be removed from the table /in drawing/

Same result I may get from filtering by instances by name

• By additional suffix &fam.inst.param.name ==*x* or manual instances indication /what is limited by  character count in single line to 80/
• But it is inconvenient / cumbersome
  
  • I have large family tables 100+ instances
  • Changes in filter, requires to change instance name - that has to match erp data
  • If few filters /few different tables are needed in drawing to show different variants/ are to be applied then fam. inst name is getting long and cumbersome
• Filtering by parameters' value is desirable.

Software - creo 4.0

Thank you in advance for any suggestions.

Regards!

[MartinHanak]

Hi,

if you upload testing data (part + drawing) then you can expect my assistance.

[BR84]

Dear Martin,

I'm happy of getting your feedback.

In an attachment, please find an example - a reference model /with examples parameters/, a drawing with tables - as you have requested.

Thank you in advance for your support,

Regards!

BR

[MartinHanak]

Hi,

please create and upload testing data.

[BR84]

Dear Martin,

In attached file, please find data for test.

Regards!

[MartinHanak]

Hi,

below mentioned solution is related to my current knowledge. I think that Creo functionality is limited and you have to use some kind of trick.

I added new parameter MUJPAR into a part (two string values are allowed YYYYY, NNNNN ... these values are used on MUJPAR, only).

I created new table containing 1 main repeat region and 4 nested repeat regions - see picture below.

main repeat region ... whole table

4 nested repeat regions ... one region per column

cell[1,1] ... &fam.inst.name, filter &fam.inst.param.value == YYYYY

cell[2,1] ... &fam.inst.param.value, filter &fam.inst.param.name  == DIA

cell[3,1] ... &fam.inst.param.value, filter &fam.inst.param.name  == LEN

cell[4,1] ... &fam.inst.param.value, filter &fam.inst.param.name  == PARAM_1

cell[5,1] ... &fam.inst.param.value, filter &fam.inst.param.name  == PARAM_2

The table displays instances which have MUJPAR parameter value set to YYYYY.

In rr_filter.prt part instance MUJPAR parameter value can be set manually.

You can also:

• open family table in Excel
• copy table contents into externally launched Excel sheet
• compute values of MUJPAR in externally launched Excel sheet
• copy computed values back into family table 

See attachment.

[BR84]

Dear Martin,

Thank you very much for your outstanding support!

I have followed  your path and got results that fulfilled initial requirements.

But, despite working on decent computer, I observed, with big tables thing get extremely slow - operations on tables are not optimized well in creo.

So I changed the method:

• I sicked to 2d repeat region table
  • and did the filtering in excel
  • I found out, admittedly you cannot apply two and more criteria on names that include certain name, by can do the very opposite - you exclusion
• I opened family table in excel
• In excel I applied a filter on row
• In parallel row I used CONCATENATE function /texts merging/
  
  • &fam.instance.name !== xxx /xxx is an instance name/ 
• returned to creo
  • pasted Excel's merged values into notepad that was opened after - repeat region -> filter -> edit

In the end it worked flawlessly and very quickly indeed.

It is a pity that Excel is not embedded in repeat region's functionality.

Thank you in for your support, and have a great rest of a day.

Pozdravy!

Best regards