Included relatedEntityData in entityBrowseRecords2

[samwoo]

Hello,

Will it ever be possible to included relatedEntityData using entityBrowseRecords2?  I'm using PowerShell and struggling to find the best way to combine individual information from the Assets Table and Assets Computer Table.  Having relateEntityData would help alleviate that.

Any thought's?

Thanks,

Samuel

[Steve G]

Hi @samwoo,

Rather than entityBrowseRecords2, you'd be best off using a stored query and the data::queryExec API to get at that information. Open up the assets list in your browser, and open up the Network console, and look at the calls to data::queryExec, specifically those that use the getAssetsListByClass query. Every time you filter the list (by asset class and/or text filtering) you should see 2 calls to that query, one to get a count and one to get the record data. This will be more efficient than us adding relatedEntityData to entityBrowseRecords2, and allows for proper pagination of the resultset.

Cheers,

Steve

[samwoo]

Hi @Steve G,

Thanks for this - I will give it a go.  I have come across that method but didnt' think to use it instead of entityBrowseRecords2.

Cheers,

Samuel

[samwoo]

Hi again @Steve G,

I remember why I didn't use that method, because I had no idea what queryNames are available - but now checking in the browser's console when doing something on the system, it now makes more sense about what's going on.  I am just wondering... are the queryNames documented anywhere? 

Anyway that worked, and is perfect... exactly what I was looking for... and surprisingly quick at returning result :O

Thanks!

Samuel

[Steve G]

Hi @samwoo,

Glad it's working for you! 

The queries are not documented as they are really just for Hornbill developers to use I'm afraid, but there's no reason why you can't use those that you spot being called directly from the UI  

Cheers,

Steve

[samwoo]

Just now, Steve G said:

Hi @samwoo,

Glad it's working for you! 

The queries are not documented as they are really just for Hornbill developers to use I'm afraid, but there's no reason why you can't use those that you spot being called directly from the UI  

Cheers,

Steve

I thought that might be the case - thanks man you have been a great help - I've learnt from the best

Have a good weekend!

Samuel

[Steve G]

@samwoo  No problem whatsoever, hope you have a great weekend too!

Cheers,

Steve