topic Re: Do queries work with strings when using esri_featurelayer_select? in ArcGIS for AutoCAD Questions

Do queries work with strings when using esri_featurelayer_select?

HenryHart — Tue, 31 Oct 2023 21:23:55 GMT

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...

Re: Do queries work with strings when using esri_featurelayer_select?

DanWade — Wed, 01 Nov 2023 13:33:20 GMT

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!

Re: Do queries work with strings when using esri_featurelayer_select?

HenryHart — Wed, 01 Nov 2023 15:48:32 GMT

Thank you for the quick reply!