nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

FeatureLayer Definition Expression

SaurabhUpadhyaya

Hi Friends,

I am trying to implement Definition Expression on Feature Layer.

In our application account and consultant are stored in db as json format {"Account": "Hospital", "Consultant": "Pediatrics"} datatype charcter varaying.

Now when i am trying to filter data on definition expression "Consultant": "Pediatrics" and it is not giving any result.

Can anyone help me

Najděte více příspěvků označených jako

Accepted answers

JoelBennett

If the JSON text is stored in string format like shown, I think you'd need a query more like the following (where "FIELD_NAME" is the name of the field being filtered):

FIELD_NAME LIKE '%"Consultant": "Pediatrics"%'

Setting the definitionExpression would then be something like:

layer.definitionExpression = "FIELD_NAME LIKE '%\"Consultant\": \"Pediatrics\"%'";

All comments

JoelBennett

My background is primarily in Oracle, and I've never used Postgres. If you're limited to standardized queries then you won't be able to do this with just a definitionExpression.

An alternative would be to query the service with the filters you can use, further filter the results on the client-side, and then add all matching features to a GraphicsLayer or client-side FeatureLayer.

SaurabhUpadhyaya

I have followed the syntax provided on https://enterprise.arcgis.com/en/server/latest/administer/linux/about-standardized-queries.htm

SaurabhUpadhyaya

Its not working.

In my postgres db data stored in character varaying datatype and values are stored in json format.

Can you please check again,

Thanks

JoelBennett

This is admittedly ugly, and there may be a better way, but in theory it should work:

FIELD_NAME LIKE '%"Consultant": "Pediatrics"%' AND TO_NUMBER(SUBSTR(FIELD_NAME, INSTR(FIELD_NAME, 1, '"Sales": ') + 9, INSTR(FIELD_NAME, 1, ', "Assets":') - (INSTR(FIELD_NAME, 1, '"Sales": ') + 9))) > 65

Some databases out there like Oracle provide native support for JSON fields, but I don't think ArcGIS necessarily supports that field type though.

SaurabhUpadhyaya

Hi @JoelBennett

Thanks for your response and it is working fine.

Now as i explained in previous question data is stored in json format where some values are integer/ double where i want to use < less than or > greater than operator in definition expression.

JSON Data : {"Account": "Hospital", "Consultant": "Pediatrics", "Sales": 65.0, "Assets": 2.5}

definition expression :

This is just an idea not exactly, want to add and Sales > 65.0 with existing definition expression ("Consultant": "Pediatrics" and Sales > 65.0)

FIELD_NAME LIKE '%"Consultant": "Pediatrics"%'

JoelBennett

If the JSON text is stored in string format like shown, I think you'd need a query more like the following (where "FIELD_NAME" is the name of the field being filtered):

FIELD_NAME LIKE '%"Consultant": "Pediatrics"%'

Setting the definitionExpression would then be something like:

layer.definitionExpression = "FIELD_NAME LIKE '%\"Consultant\": \"Pediatrics\"%'";

UndralBatsukh

It should be layer.definitionExpression = "Consultant = 'Pediatrics'"

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.