How to find record on front end

[rabii]

Hi Guys,

Does anyone know how can i retrieve data from database from front-end specifically from a view, how can the code below be translated into front-end javascript code:

$collection = $entityManager ->getRDBRepository($entityType) ->where([ // where clause 'type' => 'Customer', ]) ->find();

Any help please. telecastg emillod item

thanks

[item]

Hi,
maybe : https://github.com/espocrm/espocrm/s...lectionFactory
front-end is very difficult for me .. now back-end too

Find this too :

https://github.com/espocrm/espocrm/blob/095f82df1c93afc428717a79714ab74d11cca2ec/client/src/views/email/list.js#L180

[rabii]

Many thanks i will have a look.

[item]

Hello Rabii, please if you find a working solution, post your solution.

[rabii]

sure i will share if i figure out how to do it.

[telecastg]

Hello,

Try this code in your view script:

// specify the scope
const entityType = "your-entity";

// specify the fields (table columns) that you wish to retrieve from the back-end as a comma separated string.
const columnNameList = "field-1, field-2, field-n";

// create a collection to hold the list of models (records) that will be retrieved from the back-end
this.getCollectionFactory().create(entityType, (myCollection) => {
    myCollection.data.select = columnNameList;
    myCollection.whereAdditional = {field: "type", type: "equals", value: "Customer"};

    // display the new collection object in the console so you can see its structure and use its attributes as desired
    console.log("myCollection = ",myCollection);

    // Be mindful of Javascript's asynchronous nature, "myCollection" will not exist until this moment. If you reference "myCollection" outside the scope of this function, it might not exist yet. To address this issue, you can use promises or callbacks.

}, this);

[rabii]

any idea to how to use promise or callback ?

[telecastg]

Here's some reference material specific to Espo:

https://docs.espocrm.com/development/view/#waiting-for-some-data-loaded-before-rendering

If you are not familiar with the concept of Javascript promises or using callbacks, I suggest that you do a Google search to find tutorials

[rabii]

got you i am familiar with promise but never seen the part of the documentation. many thanks for putting me into the right direction.

[telecastg]

You're welcome