DFDM Modifications to Allow UDT Field Lookups

When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.

The tag in question is the "UDFTBL" tag.

This particular field uses validation to perform a query lookup against a UDT. This allows a user to select a value from that field (this was basically what UDTs are designed to do), but I am now wondering if I can create another multi-line field using any random field to start with, but manipulate the tags within it to perform a "FIND" in another column within that UDT - if provided a key.

So in another field, if I could change the UDFTBL tag to: UDFTBL=AR_UDT_CUSTOMER_AP_PORTALS, is it possible to pass the UDT's key field and retrieve the column UDF_AP_PORTALDESC within that UDT?

I've tried the following and some of it may be correct (likely not) and I could just be missing additional tags:

  • FIELD=<KeyValue>
  • KEY=<KeyValue>

Along with UDFCOL=UDF_AP_PORTALDESC

So a full example that I've tried would be UDFTBL=AR_UDT_CUSTOMER_AP_PORTALS;FIELD=OPENINV$;UDFCOL=UDF_AP_PORTALDESC

But I am not having any success. I know I can use probably use the UDT_Maint BOI in an event script to load this, but I am very curious if this can work without scripting. The fact that UDFTBL allows pointing to a specific table makes me think that this should work and I prefer to not use a script if there's an alternative, I just don't know a lot about Nomads tags.

And just to clarify, I am only wanting to perform a lookup/FIND. I am not attempting to update data in the UDT (so this field will be disabled to the end user). I will still likely update the UDT via a script when that is needed.

Parents
  • 0

    When the UDF is set up for UDT validation, you can display secondary columns from the UDT on the panel without an additional selection.

  • 0 in reply to Kevin M

    The only way I was able to accomplish this was by creating another UDF in the table itself and linking it which is just additional redundant clutter because the main table now has to store the column description that is already stored in the UDT.... Unless there's something that I am missing. 

    This is how it's currently being done but if I can perform a lookup without the need of additional UDFs in the main table then that would be preferred (to which I can then delete the additional UDFs - which is the goal).

    It's not so much of a problem with this particular example as we are only dealing with two columns here as it is with another UDT cross-reference lookup I would have also applied this to (which has many more columns and is used for Credit releases - so Request by & date / status / reviewed by & date / comments, etc)

Reply
  • 0 in reply to Kevin M

    The only way I was able to accomplish this was by creating another UDF in the table itself and linking it which is just additional redundant clutter because the main table now has to store the column description that is already stored in the UDT.... Unless there's something that I am missing. 

    This is how it's currently being done but if I can perform a lookup without the need of additional UDFs in the main table then that would be preferred (to which I can then delete the additional UDFs - which is the goal).

    It's not so much of a problem with this particular example as we are only dealing with two columns here as it is with another UDT cross-reference lookup I would have also applied this to (which has many more columns and is used for Credit releases - so Request by & date / status / reviewed by & date / comments, etc)

Children