OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: abdeshpa on June 25, 2015, 02:59:00 PM

Title: Mapping single folder field with multiple AG fields
Post by: abdeshpa on June 25, 2015, 02:59:00 PM
Hi All,

Is there any document on how I can use multiple mapping in folder.
I have 6 AG fields which I need to map to a single folder field.
Is this doable?

Also, is there a good document which can guide on how to use advanced information tab in the AG?

Thanks in advance.

Thanks
AD
Title: Re: Mapping single folder field with multiple AG fields
Post by: Alessandro Perucchi on July 07, 2015, 09:15:03 AM
Hello

Could you explain a little bit better what you want to achieve?

I mean if you have the following situation:

- AG1
    - Field1-1
    - Field1-2
    - Field1-3

- AG2
    - Field2-1
    - Field2-2

- AG3
    - Field3-1
    - Field3-2
    - Field3-3


And you have your folder

- Folder
    - Field 1
    - Field 2

Then what you could do is the following:

- Field 1 is mapped with
      - Field1-1
      - Field2-2
      - Field3-1

If it that is the case, then you have simply to choose in the mapping tab on the folder definition, select the folder field "Field 1", and the corresponding application field (first AG1 and Field1-1), and then repeat the operation with AG2 and Field2-2 and finally with AG3 and Field3-1.


Does that answer your question?

If not, could you a little bit more explicit on what you are trying to do?
Title: Re: Mapping single folder field with multiple AG fields
Post by: abdeshpa on May 03, 2016, 07:32:31 AM
Quote from: Alessandro Perucchi on July 07, 2015, 09:15:03 AM
Hello

Could you explain a little bit better what you want to achieve?

I mean if you have the following situation:

- AG1
    - Field1-1
    - Field1-2
    - Field1-3

- AG2
    - Field2-1
    - Field2-2

- AG3
    - Field3-1
    - Field3-2
    - Field3-3


And you have your folder

- Folder
    - Field 1
    - Field 2

Then what you could do is the following:

- Field 1 is mapped with
      - Field1-1
      - Field2-2
      - Field3-1

If it that is the case, then you have simply to choose in the mapping tab on the folder definition, select the folder field "Field 1", and the corresponding application field (first AG1 and Field1-1), and then repeat the operation with AG2 and Field2-2 and finally with AG3 and Field3-1.


Does that answer your question?

If not, could you a little bit more explicit on what you are trying to do?


No, I was looking to do mapping like below -

Field 1 of the folder is mapped with -
- Field 1-1 of AG1
- Field 1-2 of AG1 &
- Field 1-3 of AG1
Title: Re: Mapping single folder field with multiple AG fields
Post by: Alessandro Perucchi on June 10, 2016, 04:45:44 PM
Quote from: abdeshpa on May 03, 2016, 07:32:31 AM
No, I was looking to do mapping like below -

Field 1 of the folder is mapped with -
- Field 1-1 of AG1
- Field 1-2 of AG1 &
- Field 1-3 of AG1

Hmmmm then no, you can only do something like that (that's standard from CMOD):

Field 1 of the folder is mapped with -
- Field 1-1 of AG1
- Field 1-2 of AG1

OR

Field 1 of the folder is mapped with -
- Field 1-2 of AG1
- Field 1-3 of AG1

Or

Field 1 of the folder is mapped with -
- Field 1-1 of AG1
- Field 1-3 of AG1

But having all three or more fields, this is not possible.

If you want to do that, then you must program yourself a new client... :-/
Title: Re: Mapping single folder field with multiple AG fields
Post by: sisusteve on July 11, 2016, 12:12:23 PM
This is possible as long as the fields are of the same type.
We have situations where folders have 15 or 20 application groups mapped to them and the Report ID field is mapped 15-20 times to the application group RPT_ID field.

Add the desired Application Groups, and Applications as necessary, to the Folder and then simply map each field accordingly.
Title: Re: Mapping single folder field with multiple AG fields
Post by: Alessandro Perucchi on July 14, 2016, 10:10:06 PM
Quote from: Steve Bechtolt on July 11, 2016, 12:12:23 PM
This is possible as long as the fields are of the same type.
We have situations where folders have 15 or 20 application groups mapped to them and the Report ID field is mapped 15-20 times to the application group RPT_ID field.

Add the desired Application Groups, and Applications as necessary, to the Folder and then simply map each field accordingly.

Hello Steve,

the question was not to map X AG into a folder.
The question was to have for one folder field the possibility to search at the same time at multiple field in the same application group.
You can do that, but you are limited to 2 fields.

The example is the following for example:

you have a folder field called "customer numero", and you want to search at the application group field "old_cus_nr" and "new_cus_nr" and "newest_cus_nr" and "very_old_cus_nr".
CMOD cannot do that yet, it can only look for 2 of them on the same AG. And you need to select in the folder field definition the option "Mapping Type" and choose the value "Operator Or" instead of "Single".

That was the question asked by the poster...