Selection criteria for structure

dev google-group-archive
1

The contents of the below dump is contained in a cfquery. How can I use a
select statement to acquire records with status.value = ‘Issued’?
Query
Execution Time: 0.11 ms
Record Count: 2
Cached: No
Lazy: No
SQL:
SELECT recordid, status
FROM recordset
recordid status
1
Struct
id
string SANLEANDRO-DUB15-00000-001US
trackingId
number 243430061
customId
string B15-1639
serviceProviderCode
string SANLEANDRO
value
string DUB15-00000-001US
Struct
value
string Issued
text
string Issued
2
Struct
id
string SANLEANDRO-DUB15-00000-001US
trackingId
number 243430061
customId
string B15-1639
serviceProviderCode
string SANLEANDRO
value
string DUB15-00000-001US
Struct
value
string Ready to Issue
text
string Ready to Issue

2

how did you generate this Query? what does the original recordset contain?

in general the recordid column should be a simple type (e.g. string) and
only show the value, e.g. SANLEANDRO-DUB15-00000-001US
same goes for the status field, which should only show “Issued”, and not
a Struct with two keys (value, text).

Igal Sapir
Lucee Core Developer
Lucee.org http://lucee.org/On 1/29/2016 10:48 AM, @trivalleybrewers wrote:

The contents of the below dump is contained in a cfquery. How can I
use a select statement to acquire records with status.value = ‘Issued’?
Query
Execution Time: 0.11 ms
Record Count: 2
Cached: No
Lazy: No
SQL:
SELECT recordid, status
FROM recordset
recordid status
1
Struct
id
string SANLEANDRO-DUB15-00000-001US

trackingId
number 243430061

customId
string B15-1639

serviceProviderCode
string SANLEANDRO

value
string DUB15-00000-001US

Struct
value
string Issued

text
string Issued

2
Struct
id
string SANLEANDRO-DUB15-00000-001US

trackingId
number 243430061

customId
string B15-1639

serviceProviderCode
string SANLEANDRO

value
string DUB15-00000-001US

Struct
value
string Ready to Issue

text
string Ready to Issue

–
Love Lucee? Become a supporter and be part of the Lucee project today!

You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+unsubscribe@googlegroups.com
mailto:lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com
mailto:lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/496ad543-3579-4e4b-a872-8132057ed351%40googlegroups.com
https://groups.google.com/d/msgid/lucee/496ad543-3579-4e4b-a872-8132057ed351%40googlegroups.com?utm_medium=email&utm_source=footer.
For more options, visit https://groups.google.com/d/optout.