Do queries work with strings when using esri_featurelayer_select?

Question

As you can see I have a point that I brought in using the plugin.

I can find this point using AutoLISP esri_featurelayer_select() command BUT ONLY if I search by objectid (which i dont want to do). See cases below, these are copy/paste from commandline output.

-------------

Command: (setq test (esri_featurelayer_select "STREETLIGHTDETAIL_BLOCKS" "" (list (cons "ATTRIBUTEQUERY" "objectid = 223838"))))

(sslength test)
1

---------------

When I try to select by blockname or dwgname, I get 0 return.

Command: (setq test (esri_featurelayer_select "STREETLIGHTDETAIL_BLOCKS" "" (list (cons "ATTRIBUTEQUERY" "blockname = AR.121"))))

(sslength test)
0

---------------

Command: (setq test (esri_featurelayer_select "STREETLIGHTDETAIL_BLOCKS" "" (list (cons "ATTRIBUTEQUERY" "dwgname = Streetlight_Detail_CLEAN.dwg"))))

(sslength test)
0

---------------

Is my query wrong? Am i handling strings wrong? I feel like i've double checked everything...

DWade · Accepted Answer

Hello Henry,

We appreciate you bringing this to our attention. We will need to update the online documentation to make this clearer.

When searching Strings we need to enclose the string portion with single quotes.

For the drawing name example:

(setq test (esri_featurelayer_select "STREETLIGHTS" "" (list (cons "ATTRIBUTEQUERY" "dwgname = 'Streetlight_Detail_CLEAN.dwg'"))))

For the block name example:

(setq test (esri_featurelayer_select "streetlights" "" (list (cons "ATTRIBUTEQUERY" "blockname = 'AR.121'"))))

The objectID works as is because this is number based. I have a field for a pole diameter and it works the same:

(setq myblock (esri_featurelayer_select "streetlights" "" (list (cons "ATTRIBUTEQUERY" "PoleDiameter = 50"))))

Thank you for using ArcGIS for AutoCAD!