Allowed Property Values - Concatenated values from multiple lists

osharp

hi,

Is there a way to check property values comprised of concatenated value lists?

e.g I have an Asset ID field which is comprised of 3 parts: (1) _ (2) _ (3)

(1) Location ID
(2) Asset Type ID
(3) 3-digit Serial

1 & 2 have predefined value lists that i would like to pull from Excel, whilst 3 should just match ???

? Offline

Hi Owen,

I’d reccommend you look at classifications as your first step, the use a ruleset to check elements have acceptable classifications.

Key to this is the use of hotkeys (honestly can’t remember the correct name), these are:

? = Any Character, this can be used to check for codes of cerain lengths

= any value, this can be used for checking that prefixed values are present

So, you could check the the ID has the right structure: __*

And if you have multiple location codes, you could have a classsifcation setup to look for each variant in the format:
LOC_*

And your 3-digit serial might use *_??? with possible *_1?? iterations for predetermined series.

Another advantage of the classifications is that you should be able to quickly update these using excel files!

Hope this helps.

osharp

hi Max,

Thanks for the help … i’m generally a fan of using Classifications to work around various issues, although they can start to slow down model updates so i’d prefer things to be done in rules where possible. I’m OK on checking the structure or syntax of the overall ID is correct, but using classifications to check the value lists i can’t see a way around having to create a classification for every combo of Location ID and Asset Type ID?

= a lot of rules, although no issue to generate using Excel. Will give it a try

osharp

nevermind … separate classifications for Location and Type will do the job. Think i should have extended the holidays!

? Offline

Agreed, classifications can slow load up and updating of models if you have to many in one model.

However, if you use them the rulesets will run in a breeze. And you’ll have a quick and easy way to colour code your models.

Whereas a rules only approach will involve checking all the values a classificaiton would do, but you’d have to wait every time you run the rules.

Depends how you want to spend your holidays

Simo_Z

Hello, everyone,

do you know if there is a list of “hotkeys” (*,?,ecc.) somewhere?

Thank you very much

Best regards
Simone

Matti

@Simo_Z said in Allowed Property Values - Concatenated values from multiple lists:

do you know if there is a list of "

star (*) and question mark (?) are the only special characters used by Solibri matcher at the moment.

star (*) = any character zero or more times
question mark (?) = any character once

You could also try rule #21 which offers custom pattern checking for ID numbers:

Checking for valid ID
Checking for uniqueness
Checking for consecutive numbers

Simo_Z

Thanks very much @Matti-Kannala!