entityReadAll with filters does not work

[MilkTicc]

I am not able to use entityReadAll to get entities with any filters. Need correct examples.
This is one of the things i tried:

let cand = await SHOTGRID.entityReadAll({
    entity: 'CustomEntity11',
    pageSize: 3,
    sort: '-created_at',
    filter:[["sg_status_list","is","cand"]]
});

[souphan-adsk]

The in-code documentation was the following:

/**
 * Read multiple entities.
 *
 * @param  {string}       options.entity       - Entity type.
 * @param  {Object}       [options.filter]     - List of filters.
 * @param  {Array|String} [options.fields]     - List of fields to show.
 * @param  {Array|String} [options.sort]       - List of ordering fields.
 * @param  {number}       [options.pageSize]   - Upper limit of items shown on response page.
 * @param  {number}       [options.pageNumber] - Position in list of items to start querying from.
 * @param  {Object}       [options.options]    - Request option settings.
 * @return {PaginatedRecordResponse} Targered partial response.
 */

Despite classifying the filter argument as Object, the description should have been read more as Key-value pair object to evaluate exact match filter. (Will correct it shortly)

So the correct usage in your case should be:

let cand = await SHOTGRID.entityReadAll({
    entity: 'CustomEntity11',
    pageSize: 3,
    sort: '-created_at',
    filter: {
        sg_status_list: 'cand'
    }
});

[MilkTicc]

Thanks a lot! What about the 'in' condition?

[MilkTicc]

Hi! I have another question: How do I filter with 'Assets'? I tried this with no luck:

let cand = await SHOTGRID.entityReadAll({
    entity: 'CustomEntity16',
    pageSize: 1,
    sort: '-created_at',
    filter: {
        'sg_asset': {'type': 'Asset', 'id': 1000, 'name':'SomeName'}
    }
});

Thanks!

[MilkTicc]

Just found the answer myself, the filter could be

filter:{
    'sg_asset.Asset.id' : 1000
}