Choose a cancelled options from multiple options and remove cancelled while querying data from database

If you don't want to display it, why retrieve it at all?

If that's the case, you'd use a!queryFilter() in your a!queryEntity() to only pull back non-cancelled rows.

Your request seems a little vague on the details of what you need to do versus what you've tried already, but it sounds like you're trying to filter a query - you can accomplish this for most use cases simply using the QueryFilter functionality within the QueryEntity function.  If you click on the "Documentation" tab above and search for articles and recipes on QueryEntity, you should find supporting details there.

Can you elaborate it please