You are viewing limited content. For full access, please sign in.

Question

Question

Is it possible to have Metadata(1) into Metadata(2) ?

asked on March 24, 2017

Hi all,

I want to know if is it possible to have metadata(2) into metadata(1) ?

Example :

||-- Metadata(1) --||-- Metadata(2) --||-- Fields

             ISS           ->      A10            ->        A10.1

                                                        ->        A10.2

                            ->      A20            ->        A20.1

                                                         ->       A20.5

 

 

I know this is special but my customer data is like that and I need to reproduce it.

 

Thank you.

Regards

0 0

Answer

APPROVED ANSWER
replied on March 27, 2017 Show version history

You may be able to use the feature released in LF 10.2 called "multi-value field groups" to describe these complex objects. For example:

Since both "Mother" and "Father" have the same set of fields, you make each field multi-valued, then use the multi-valued field groups to correlate the sets of values.

The grouping is also used when searching, so you can, for example, search only on a father's first name.

I have more information on multi-valued fields in my presentation on Advanced Metadata for Administrators.

 

Looking at your spreadsheet, you might have fields name "Code métadonnées principales", "Code métadonnées secondaires", and "Code champs", then make that a field group so that you can have multiple sets. Basically, use the first field of a field group as a label to distinguish the type.

1 0

Replies

replied on March 24, 2017

I don't understand what you are asking.  Do you want to modify metadata, or is this a display enhancement?  What do the arrows in your diagram signify?  What product(s) would this impact?  A concrete use case (rather than "Metadata(1)") might make it easier to understand.

0 0
replied on March 24, 2017 Show version history

Are you asking if you can make one field depend on what you have selected for another, like dynamic fields?

For example, if you have selected "ISS" for your first field, the second field should have options for only A10 and A20, and if you select A10 in the second field, your third field shows options like A10.1, A10.2.

0 0
replied on March 27, 2017

Hi all, and thank you.

 

Brian McKeever, this is more a a display enchancement, but actually this is juste a simple by curiosity.

Brianna Blanchard, no this is not a dynamic fields.

 

I know this is not very clear. Trying to explain with picture.

I have Metadata 1 with Field A and B.

 

I have the same with Metadata 2 (Field A and B too).

Now I want to know if I can have a SuperMetaData with inside Metadata 1 and Metadata 2.

 

Let's make an example :

Field A = Lastname

Field B = Firstname

 

Metadata 1 = Father

Matadata 2 = Mother

 

So you have :

Father {Lastname,Firstname} and Mother {Lastname,Firstname}, right?

Now, SuperMetaData = Parent

Parent {Father,Mother}. In this example, Father and Mother are not a fields but there are a metadata.

At the end this is what I should have

Parent {Father's Lastname, Father's Firstname, Mother's Lastname, Mother's Firstname}

 

I dont want to create Fields "Father's Lastname,..." because in my example, I have only 4 fields, but my client have 280 fields like that.

 

I shared xlsx file with all the fields I need to use (this is in french but all  you need to know is Column F are the fields, D the matadata, and B the SuperMetaData).

 

Thanks you.

 

0 0
replied on March 27, 2017 Show version history

Olivier,

My interpretation is that you are trying to store a complex data type in a text metadata field?  If that is the case then perhaps you could create and serialize that complex object into an XML string in a Workflow script activity  and then store that data in a text field? 

The other (simpler) option would be to just concatenate the elements into the format that you require (again in Workflow).  i.e. "Parent {Doe, John, Doe, Jane}"

Or am I missing something?

1 0
replied on March 27, 2017

Thank you Cliff Primmer.

You right! I'm trying to store a complex data type. I'm going to try your solution.

Thank you.

0 0
replied on March 27, 2017

Something to keep in mind is that there is a 4000 character limit on a metadata text field (not sure if you would ever try to store a text field that large though)

0 0
APPROVED ANSWER
replied on March 27, 2017 Show version history

You may be able to use the feature released in LF 10.2 called "multi-value field groups" to describe these complex objects. For example:

Since both "Mother" and "Father" have the same set of fields, you make each field multi-valued, then use the multi-valued field groups to correlate the sets of values.

The grouping is also used when searching, so you can, for example, search only on a father's first name.

I have more information on multi-valued fields in my presentation on Advanced Metadata for Administrators.

 

Looking at your spreadsheet, you might have fields name "Code métadonnées principales", "Code métadonnées secondaires", and "Code champs", then make that a field group so that you can have multiple sets. Basically, use the first field of a field group as a label to distinguish the type.

1 0
replied on March 28, 2017

Ouav, thank you Brianna Blanchard! It's amazing! Going to look your presentation and try your solution.

Thank you.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.