topic Dynamic text value with SQL Expression return first record in ArcGIS Pro Questions

Dynamic text value with SQL Expression return first record

ZacharyHart — Wed, 18 Jan 2023 14:44:57 GMT

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:

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?

Re: Dynamic text value with SQL Expression return first record

KariBuckvold — Thu, 12 Oct 2023 19:23:24 GMT

did you ever figure this out? I would really like to do this as well!

Re: Dynamic text value with SQL Expression return first record

ZacharyHart — Thu, 12 Oct 2023 19:29:30 GMT

Supposedly the Arcade Distinct function will be working in the 3.2 release...(several years after it was first shown in the documentation).

You can read comments from others here.

Re: Dynamic text value with SQL Expression return first record

KariBuckvold — Thu, 12 Oct 2023 20:54:31 GMT

thanks for the reply, @ZacharyHart ,too bad we can't use python and use 'set' in the meantime.