Answered

Ordering a GetEntityList result set

Dear support Team,

I wish to know how to ordering a getEntityList result set on a determined order (ascending or descending). Unfortunately the 4'th function argument do not admit ASC or DES complement.

Example:

var TabPreco = CEntityManager.GetEntity("TabelaValoresAtend").GetEntityList("",lsFilter,"","DataInicial ASC");

Error message:

Error: Error processing Rule =31dd3f77-79dd-49d7-9861-910013f98368; Error: Error Evaluating Rule 10008 - Error Display, filter or order attribute not found. Entity ID: TabelaValoresAtend. - bad xpath or Attribute not found: DataInicial ASC..

Thanks,

Pedro Gentil

    photo
    0

    Dear Pedro

    Please check out your sintaxis, taking into account the following syntax of the EntityManager function:

    CEntityManager.GetEntity("Entity").GetEntityList("Attribute","Filter","Search","Order");

    take special attention to quotes and commas (see image)

    9fg

    Best regards

    Luis EMilio

    photo
    0

    Dear Luis,

    Your statatment is the same of mine...

    var TabPreco = CEntityManager.GetEntity("TabelaValoresAtend").GetEntityList("",lsFilter,"","DataInicial ASC");

    9fg

    Its is true?

    Thanks a lot

    photo
    0

    Pedro Gentil wrote:

    Dear Luis,

    Your statatment is the same of mine...

    var TabPreco = CEntityManager.GetEntity("TabelaValoresAtend").GetEntityList("",lsFilter,"","DataInicial ASC");

    9fg

    Its is true?

    Thanks a lot

    Dear Pedro

    Concerning your questions, yes, its the same statement, I just showing you where you must put the quotes, and colons, please try whit he following line:

    var TabPreco = CEntityManager.GetEntity("TabelaValoresAtend").GetEntityList("",lsFilter,"","DataInicial", "ASC");

    beste regards

    Luis EMilio