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.

[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