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

REPEAT REGION FILTERS BY PARAMETER VALUE

Marble

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

Re: REPEAT REGION FILTERS BY PARAMETER VALUE

Hi,

 

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


Martin Hanák

Re: REPEAT REGION FILTERS BY PARAMETER VALUE

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

Re: REPEAT REGION FILTERS BY PARAMETER VALUE

Hi,

 

please create and upload testing data.


Martin Hanák

Re: REPEAT REGION FILTERS BY PARAMETER VALUE

Dear Martin,

 

In attached file, please find data for test.

 

Regards!

Re: REPEAT REGION FILTERS BY PARAMETER VALUE

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

Re: REPEAT REGION FILTERS BY PARAMETER VALUE

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

Announcements
LiveWorx Call For Papers Happening Now!