converting container to hash key.

(0) Share

Report

Posted on by Community Member

Hello,
I see that container cannot be used as an index in table.

I want to convert a container to hash value, I can use that hash value as an index of a table (It is not preferred, but it may be duplicate sometimes).

Is there any function converting container to an hash value (string or long number)?

Thanks :)

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Eitan,

I've no idea if it answers your question, but I notice that there's a class on the table InventDim called hashValue which, erm, calculates a hash value.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I got exception that constractFromContainer has invalid parameters

(parameter: ['a', 'b', 'c', d'])

I think that MD5 or CRC are fine.

found: krishhdax.blogspot.co.il/.../useful-functions-to-use-in-ax2012.html

- didn't check it yet.

Thanks :)

Was this reply helpful? Yes No
Martin Dráb 237,987 Most Valuable Professional on at

Like (0)

Report

There is infinite number of ways how to compute a hash and, of course, different implementations and different hash algorithms have different properties. So it's not easy to answer your question unless you tell us more about your requirements.

Above all, what data types are in the container and which kind of hash do you want to get?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

My requirement is convert the container to index, and use it in x++ select statement.

Container is a field in db, and because it cannot be indexed, I shall convert it to some data.

I guess i can do that by using view with calculated column, like this:

The function of the calculated column may return something like

substring(sys.fn_sqlvarbasetostr(HashBytes('MD5', keycontainer)), 3, 32)

and using that view in my select statement.

But it is better, I can use the above link and add a new column in order to set the hashkey as an index.

I think this solve the mentioned problem.

Thanks, anyway :)

Was this reply helpful? Yes No