Assets Comparing an Integer to another Integer

[Tim Patrick]

Hi,

Scenario:

• Attribute 1 is Current Stock Level
• Attribute 2 is Restock Level

All i want to do is show on a confluence page an asset table which shows any objects where the Current Stock Level value is below the Restock Level value.

Thanks

[Marc -Devoteam-]

Hi @Tim Patrick 

Have you been able to get such results using an AQL?

If you have, you could use the assets macro in Confluence and use the same AQL and see the results.

[Tim Patrick]

Yes its on confluence that we would like to see the results. 

We just want to show the objects that have a Current Stock Level that is lower than the Restock Level. 

Any idea of what formula i need to stick in to get this to behave?

[Marc -Devoteam-]

Hi @Tim Patrick 

I don't think there is an option to query this.

You might need a scheduled automation that gets the values from the attributes you mention, stor them into separate variables an then compare them.

Based on the compare set another attibute on the object with a status or boolean option.

Then in Confluence use the Assets macro to show the objects where the status or boolean attribute has the set value.

[Valerie Knapp]

Hi @Tim Patrick , thanks for your post.

Is using Confluence databases an option instead?

What is the requirement? You would have a Jira work item with two assets type custom fields? Then, you want to do a comparison between those two numbers? What would be shown in Confluence? The Jira work item?

In Confluence databases, you could have a table with the Current Stock and Restock levels and just do the mathematical operations there. Maybe you have some integration with Assets? Is that the reason for needing to use Jira?

If you could explain a bit more your setup and what you are wanting to achieve, that would be helpful for us to help you troubleshoot.

Best wishes

[Tim Patrick]

Hi,

We have an inventory set up in Jira Assets which is working nicely.

The requirement is just to have an asset table on confluence that only shows items where the Current Stock Level is a lower value to the Restock Level.

Both attributes are set up as Float as we require decimal values.

Thanks

[Valerie Knapp]

Hi @Tim Patrick , thanks for your comment. 

On @Marc -Devoteam- 's suggestion, I tried to get something to work using the Assets macro in Confluence but I don't see how you can do the confrontation between the results of these two macros:

Where the first table is the representation of this folder of TV objects, filtered by the TV model:

And the second macro is the object of TV model, with the restock figure

This is why I suggested Confluence databases because to be able to count the rows in the Confluence Assets macro and then compare this number with the restrock number, which is an attribute of another Asset in the other macro.... seems a bit too much for Confluence in this moment.

Maybe you could do something with ScriptRunner but I am not someone who can help with that unfortunately.

Best wishes

[Tim Patrick]

No worries. Thanks for trying.