In AF linked a table that contains a field when the record was created. The join statement when I created the link returns one record. How can I pull out the oaId from the table using DR. Can't figure a where clause to use.
Based on the lack of response, I assume that either I did not clarify the question well enough or there is not a way to get the results I need from AF. Therefore I am going a different route. When I create the record I will store the record number as a pi point. Then use that pi point as an attribute in AF. That way I can use it in my where clause to get the data that I need.
Sorry you did not receive a response. I think it was unclear to other users what the issue was (what is the "oald" data, for example). It sounds like you have settled on using the RDBMS interface to bring the data into tags which is a good solution when the table updates frequently (say, more that once/day). If you have need to revisit an AF table based solution for this or another application, it would be helpful to give a sample of the table structure and data you are accessing in SQL and the queries you are using for the Linked table setup and the Table Lookup DR. Thanks for your active participation in the Community!
Retrieving data ...