On Tuesday, August 4, 2020 at 10:07:31 AM UTC-7, bee...@gmail.com wrote:
>
> Even larger, this follows the block and internal qualifiers, but has an
> undefined method '&':
>
> where{{pcid: freebies_array} &
> (listing[:product_name].ilike(submitted.to_s)) & {listing[:status] =>
> 'active'}}.
>
...and is there any overhead on splitting them up into compound ".where..."
clauses?
On Tuesday, August 4, 2020 at 1:07:31 PM UTC-4 bee...@gmail.com wrote:
> Even larger, this follows the block and internal qualifiers, but has an
> undefined method '&':
>
> where{{pcid: freebies_array} &
> (li
Even larger, this follows the block and internal qualifiers, but has an
undefined method '&':
where{{pcid: freebies_array} &
(listing[:product_name].ilike(submitted.to_s)) & {listing[:status] =>
'active'}}.
Doesn't say which ampersand is the issue. First qualifier there is "pcid
IN "
On Tue
On Tuesday, August 4, 2020 at 9:49:15 AM UTC-7, bee...@gmail.com wrote:
>
> How do you combine multiple items in a virtual row block?
>
> where{{listing[:product_name].ilike(submitted.to_s), listing[:status] =>
> 'active'}}.
>
where{listing[:product_name].ilike(submitted.to_s) & {listing[:status]
How do you combine multiple items in a virtual row block?
where{{listing[:product_name].ilike(submitted.to_s), listing[:status] =>
'active'}}.
On Tuesday, August 4, 2020 at 12:45:52 PM UTC-4 bee...@gmail.com wrote:
> Ah was combining the two concepts. Thank you.
>
> On Tuesday, August 4,
Ah was combining the two concepts. Thank you.
On Tuesday, August 4, 2020 at 12:44:36 PM UTC-4 bee...@gmail.com wrote:
> r = a.where{{id > 20, listins[:status]=>'active'}}
>
> error: unexpected '}'
>
>
> On Tuesday, August 4, 2020 at 11:04:22 AM UTC-4 bee...@gmail.com wrote:
>
>> Hi there. I'm
r = a.where{{id > 20, listins[:status]=>'active'}}
error: unexpected '}'
On Tuesday, August 4, 2020 at 11:04:22 AM UTC-4 bee...@gmail.com wrote:
> Hi there. I'm confused about the syntax of filtering records whose status
> is 'active'. I can't format it the way I like (fieldname: 'active')
tables have the 'status' field.
>
> So I have to include the tablename, then the fieldname, as
> `tablename[:fieldname]`. Even using `tablename[:fieldname] => 'status'` is
> giving me an error.
>
That is because you are not inside a virtual row block.
Hi there. I'm confused about the syntax of filtering records whose status
is 'active'. I can't format it the way I like (fieldname: 'active')
because in this join, two tables have the 'status' field.
So I have to include the tablename, then the fieldname, as
`tablename[:fieldname]`. Even u