Experimenting a bit with dynamic text and table attributes which is listed as 'value' in the dynamic text dialog.
I see you can use a few options that would limit the resulting return for 'All records', 'Visible records', and 'Custom Query'. The custom query expression uses SQL and would have a default of something like: sql="OBJECTID = 1". You can use the SQL expression builder but unfortunately it does not recognize table names which is unfortunate.
A typical dynamic text may look like this:
<dyn type="table" property="value" mapFrame="Main Map Frame" mapMemberUri="CIMPATH=location_map/forest_types.json" sql="OBJECTID = 1" arcade="'CLIENT: '+$feature.CLIENT" delimiter=" "/>
I'd like to be able to use an SQL statement to return only the first record but not having any luck.
SELECT FIRST(column_name) FROM table_name;
Is any of this possible?