When building a query, I can't find a way to build the query with a string for a select field, it has to be the numerical ID for the value. 

for example:

query_builder.equals(fields.incident.testselect, "Test1")
query = query_builder.build()
incidents = helper.findIncidents(query)

would not work, but replacing the first line with:

query_builder.equals(fields.incident.testselect, 123)

would work (replacing 123 with the ID for that value)

I've tried to find a way of using the label property rather than value, but it doesn't seem possible. Am I doing something wrong, or can you not create a query on a select field with a string?

------------------------------
Thomas Spray
------------------------------

Hi Thomas,

I think you're correct there, there doesn't seem to be a way to specify a string value, only ID from what I can see.
This is something that will have to be discussed and dealt with by the development team unfortunately.

Thanks,
Paul.

(P.S. if any workarounds present themselves, I will come back here and update the post)

------------------------------
PAUL CURRAN
------------------------------

Original Message:
Sent: Thu May 02, 2019 05:24 AM
From: Thomas Spray
Subject: query_builder query on select fields

When building a query, I can't find a way to build the query with a string for a select field, it has to be the numerical ID for the value. 

for example:

query_builder.equals(fields.incident.testselect, "Test1")
query = query_builder.build()
incidents = helper.findIncidents(query)

would not work, but replacing the first line with:

query_builder.equals(fields.incident.testselect, 123)

would work (replacing 123 with the ID for that value)

I've tried to find a way of using the label property rather than value, but it doesn't seem possible. Am I doing something wrong, or can you not create a query on a select field with a string?

------------------------------
Thomas Spray
------------------------------

Any update on this? It has been 4 years already 💀

------------------------------
Émilio Gonzalez
------------------------------

Original Message:
Sent: Fri May 03, 2019 11:13 AM
From: Paul Curran
Subject: query_builder query on select fields

Hi Thomas,

I think you're correct there, there doesn't seem to be a way to specify a string value, only ID from what I can see.
This is something that will have to be discussed and dealt with by the development team unfortunately.

Thanks,
Paul.

(P.S. if any workarounds present themselves, I will come back here and update the post)

------------------------------
PAUL CURRAN

Original Message:
Sent: Thu May 02, 2019 05:24 AM
From: Thomas Spray
Subject: query_builder query on select fields

When building a query, I can't find a way to build the query with a string for a select field, it has to be the numerical ID for the value. 

for example:

query_builder.equals(fields.incident.testselect, "Test1")
query = query_builder.build()
incidents = helper.findIncidents(query)

would not work, but replacing the first line with:

query_builder.equals(fields.incident.testselect, 123)

would work (replacing 123 with the ID for that value)

I've tried to find a way of using the label property rather than value, but it doesn't seem possible. Am I doing something wrong, or can you not create a query on a select field with a string?

------------------------------
Thomas Spray
------------------------------