Selection criteria for structure

[trivalle...@gmail.com]

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

[Igal @ Lucee.org]

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

--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
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+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/496ad543-3579-4e4b-a872-8132057ed351%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.