How to exclude objects to be positioned?

[axhamre]

I have a Rails app where a Category has many Post.

scope: :category in the Post class is automatically giving position to posts withing the same category.

How could I exclude posts that has the attribute publishedset to false to be part of the positioning?

[swanandp]

The following should work; can you try and let me know?

acts_as_list scope: 'category = #{category_id} AND published = 0'

[axhamre]

I had to change category to category_id to avoid getting the following error message:

ActiveRecord::StatementInvalid: SQLite3::SQLException: no such column: category: SELECT COUNT(*) FROM "questions" WHERE (category = 2 AND published = 1 AND position = 4)

But the methods don't seem to work properly anymore. E.g. remove_from_list sets the position attribute to nil but the list isn't reordered anymore as it usually is.

Is there anything additionally I should think about to achieve the "normal" behaviour of acts_as_list but on a restricted set of items?

[swanandp]

Work is in progress to support lambdas as scopes, but for now if 0.4.0 is not working for you, you can try 0.3.0

[axhamre]

Thank you!

[axhamre]

Six years later, and I ask myself the same thing all over again. But this time around I feel more comfortable looking for the answer in the source code :)

This works great:

acts_as_list scope: [:category_id, published: false]

[brendon]

Haha! Great to see that feature worked for you :) It's certainly been much easier for me since learning to dive into gems and figure things out for myself. If you think this can be better documented, feel free to do a PR for documentation improvement :)