cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

REPEAT REGION FILTERS BY PARAMETER VALUE

BR84
12-Amethyst

REPEAT REGION FILTERS BY PARAMETER VALUE

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!

6 REPLIES 6
MartinHanak
24-Ruby II
(To:BR84)

Hi,

 

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


Martin Hanák
BR84
12-Amethyst
(To:MartinHanak)

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
24-Ruby II
(To:BR84)

Hi,

 

please create and upload testing data.


Martin Hanák
BR84
12-Amethyst
(To:MartinHanak)

Dear Martin,

 

In attached file, please find data for test.

 

Regards!

MartinHanak
24-Ruby II
(To:BR84)

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.

rr1.png

 

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.


Martin Hanák
BR84
12-Amethyst
(To:MartinHanak)

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

Top Tags