search

xbrlus / xule

An open-source XBRL processor for business rules, rendering and custom data reporting. See https://xbrl.us/xule for documentation and https://xbrl.us/xule-editor for a VS Code syntax highlighter.
Apache License 2.0
25 stars 10 forks source link

Where filter for concept ids in summation-item queries #14

Closed BrittMcDanel closed 1 year ago

BrittMcDanel commented 1 year ago

I am trying to include ids in the where filter for summation-item queries:

namespace us-gaap=http://fasb.org/us-gaap/2022
namespace mas=https://www.sec.gov/Archives/edgar/data/62996/000006299622000041/mas-20220930.xsd

output query-test
navigate summation-item parents from us-gaap:ProfitLoss where $source.id == "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfNy0xLTEtMS05MzA5OQ_c5ea3522-659e-426d-8097-9d7b4124ec51"

But this does not seem to work, is there support for something like this? Thanks!

campbellpryde commented 1 year ago

The source id looks like a fact identifier key. The navigate works on the taxonomy and not attributes of an instance document. What are you trying to do with this expression?

Campbell Pryde

President and CEO

XBRL US Inc.

@. @.>*

https://xbrl.us https://xbrl.us

[image: XBRL US]

The non-profit community https://xbrl.us/xusmembers improving U.S. reporting through a free, open standard https://xbrl.us/home/learn/free-open-standards/.

On Thu, Jan 19, 2023 at 11:46 AM Britt McDanel @.***> wrote:

I am trying to include ids in the where filter for summation-item queries:

namespace us-gaap=http://fasb.org/us-gaap/2022 namespace mas=https://www.sec.gov/Archives/edgar/data/62996/000006299622000041/mas-20220930.xsd

output query-test navigate summation-item parents from us-gaap:ProfitLoss where $source.id == "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfNy0xLTEtMS05MzA5OQ_c5ea3522-659e-426d-8097-9d7b4124ec51"

But this does not seem to work, is there support for something like this? Thanks!

— Reply to this email directly, view it on GitHub https://github.com/xbrlus/xule/issues/14, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADC2RF66A23ORFVKEPA74DLWTFVX3ANCNFSM6AAAAAAUAR45YM . You are receiving this because you are subscribed to this thread.Message ID: @.***>

BrittMcDanel commented 1 year ago

Thanks for your reply.

I am trying to get the parent ids for a given table cell id. For example, see the ix:nonnumeric tag below:

nonnumeric

In the nonnumeric tag there is the concept name "us-gaap:ProfitLoss" and the id given in the property name "data_original_id" (it is the long id, don't want to paste it all here).

When I do the query:

namespace us-gaap=http://fasb.org/us-gaap/2022
namespace mas=https://www.sec.gov/Archives/edgar/data/62996/000006299622000041/mas-20220930.xsd

output query-test
navigate summation-item parents from us-gaap:ProfitLoss

I get back a list of strings names (something like "us-gaap:NetIncome", etc). These values are over the entire filing though, and I want to be able to do more fine-grained queries. So I would like to do the same query but for a given data_original_id, returning a list of data_original_ids back. Something like:

namespace us-gaap=http://fasb.org/us-gaap/2022
namespace mas=https://www.sec.gov/Archives/edgar/data/62996/000006299622000041/mas-20220930.xsd

output query-test
navigate summation-item parents from {data_original_id}

Thanks again

campbellpryde commented 1 year ago

The navigate is for navigating taxonomy relationships, so the parents of profit loss are the elements that profit loss in a component of. The navigate will not give you the id's of these parents directly. You would have to do the following:

$parentConcepts = navigate summation-item parents from us-gaap:ProfitLoss

This will give you a list of the parent concepts if there is more than

  1. This will be across all disclosures section of the filing where ProfitLoss in in a calc. If you wan to restrict it to a disclosure you will need to know

where this fact is disclosed and limit the navigate to that role. i.e. $parentConcepts = navigate summation-item parents from us-gaap:ProfitLoss role $IncomeStatement

Next you need to get the fact you are referring to:

$ProfitLossFacts = @.*** = us-gaap:ProfitLoss where $fact.id="id3Yy...."})

Then you need to get the fact ids of the parent elements.

for $ProfitLossFact in $ProfitLossFacts

 $ParentIds = ***@***.*** in $parentConcepts}.id)

  $ParentIds

This will return a list of the parent id's in the same period, and dimensions as the fact you requested.

Alternatively if you want to get the id of the text block that this is fact appears in in the inline file, then that is different. XUle will support that in the next release (1.2) at the end of the month.

That will allow you do do the following: $parentFacts = @.*** = us-gaap:ProfitLoss where $fact.id="id3Yy...."}. inline-parents $parentFacts.id

Campbell Pryde

President and CEO

XBRL US Inc.

@. @.>*

https://xbrl.us https://xbrl.us

[image: XBRL US]

The non-profit community https://xbrl.us/xusmembers improving U.S. reporting through a free, open standard https://xbrl.us/home/learn/free-open-standards/.

On Thu, Jan 19, 2023 at 2:16 PM Britt McDanel @.***> wrote:

Thanks for your reply.

I am trying to get the parent ids for a given table cell id. For example, see the ix:nonnumeric tag below:

[image: nonnumeric] https://user-images.githubusercontent.com/9492093/213537946-9f178964-9741-4d94-95e4-7ce07b37cbc9.png

In the nonnumeric tag there is the concept name "us-gaap:ProfitLoss" and the id given in the property name "data_original_id" (it is the long id, don't want to paste it all here).

When I do the query:

namespace us-gaap=http://fasb.org/us-gaap/2022 namespace mas=https://www.sec.gov/Archives/edgar/data/62996/000006299622000041/mas-20220930.xsd

output query-test navigate summation-item parents from us-gaap:ProfitLoss

I get back a list of strings names (something like "us-gaap:NetIncome", etc). These values are over the entire filing though, and I want to be able to do more fine-grained queries. So I would like to do the same query but for a given data_original_id, returning a list of data_original_ids back. Something like:

namespace us-gaap=http://fasb.org/us-gaap/2022 namespace mas=https://www.sec.gov/Archives/edgar/data/62996/000006299622000041/mas-20220930.xsd

output query-test navigate summation-item parents from {data_original_id}

Thanks again

— Reply to this email directly, view it on GitHub https://github.com/xbrlus/xule/issues/14#issuecomment-1397481936, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADC2RF2QSH7AY5PJTOWLOPTWTGHG7ANCNFSM6AAAAAAUAR45YM . You are receiving this because you commented.Message ID: @.***>

BrittMcDanel commented 1 year ago

Thanks for the reply. Are the uuids at the end of the id added for each query? If I run:

def xule_build_data_query(filing, concept_tag):
    '''
    Builds a Xule query to get the data for a concept name (i.e 'us-gaap:ProfitLoss').
    '''
    query = 'namespace us-gaap=http://fasb.org/us-gaap/2022\n'
    query += 'namespace dei=http://fasb.org/dei/2022\n'
    query += 'namespace ' + filing['name'] + '=' + filing['xsd_file_url'] + '\n'
    query += '\noutput query-test\n\n'
    query += '{@concept = ' + concept_tag + '}\n'
    query += '''message "local_name: {$rule-value.concept.local-name}
         period: {$rule-value.period}
         id: {$rule-value.id}
         fact: {$rule-value}
         unit: {$rule-value.unit}
         decimals: {$rule-value.decimals}
         balance: {$rule-value.concept.balance}
         period_type: {$rule-value.concept.period-type}
         label: {$rule-value.concept.label.text}
         is_monetary: {$rule-value.is-monetary}
         is_numeric: {$rule-value.is-numeric}
         inline_scale: {$rule-value.inline-scale}
         inline_negated: {$rule-value.inline-negated}
         inline_format: {$rule-value.inline-format}
         inline_display_value: {$rule-value.inline-display-value}
         inline_hidden: {$rule-value.inline-hidden}"'''
    return query

for us-gaap:ProfitLoss I always get 12 results, but the ids change on each run (though some of them are the same). For example, here are the ids for run one:

[
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfMTEtMS0xLTEtOTMwOTk_bbc2b7b1-32ed-48d5-a527-b7d6f9958bac",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfMTEtMy0xLTEtOTMwOTk_b3123b53-993e-4f4f-b7b6-dffd182a3b6a",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfMTEtNS0xLTEtOTMwOTk_453e463c-46ca-4fd4-863c-d372411602aa",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfMTEtNy0xLTEtOTMwOTk_11fd580c-a27b-4880-ae0d-1ff3e57aa251",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfNy01LTEtMS05MzA5OQ_cc16fa68-86d2-483d-b138-edeaaae1670d",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfNy03LTEtMS05MzA5OQ_4bbc98be-806c-4bdf-b4c2-bd8ac26ab6cf",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfNy0xLTEtMS05MzA5OQ_c5ea3522-659e-426d-8097-9d7b4124ec51",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfNy0zLTEtMS05MzA5OQ_661b1621-f87a-4e6d-b978-3e26adce211e",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl8xOS9mcmFnOmMyODhkYWExMjgxNzRiZmI4ZGVmMDAxMDgzNzM3ZTMyL3RhYmxlOjljMTk4NzkzMjBlNjQzOWM4YjliN2QzYzYwZGMwMGViL3RhYmxlcmFuZ2U6OWMxOTg3OTMyMGU2NDM5YzhiOWI3ZDNjNjBkYzAwZWJfMTQtMy0xLTEtOTMwOTk_c4dbac54-ef55-4a9f-846e-401873eec0cd",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl8xOS9mcmFnOmMyODhkYWExMjgxNzRiZmI4ZGVmMDAxMDgzNzM3ZTMyL3RhYmxlOjljMTk4NzkzMjBlNjQzOWM4YjliN2QzYzYwZGMwMGViL3RhYmxlcmFuZ2U6OWMxOTg3OTMyMGU2NDM5YzhiOWI3ZDNjNjBkYzAwZWJfMTQtNy0xLTEtOTMwOTk_b8fd0f0c-1823-4ec2-98c9-9057491559bf",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl8yMi9mcmFnOmQxMDA4OWM4OGUzNTQ2MmY4YTgwMjBiYWI3Mjg0MTViL3RhYmxlOjE0MzBhZmRkZmVhOTQ1NDc4N2Q1MTg2OTNhMzdhZTA4L3RhYmxlcmFuZ2U6MTQzMGFmZGRmZWE5NDU0Nzg3ZDUxODY5M2EzN2FlMDhfMi01LTEtMS05MzA5OQ_8888839f-97a7-4316-a882-36853c0b3b4c",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl8yMi9mcmFnOmQxMDA4OWM4OGUzNTQ2MmY4YTgwMjBiYWI3Mjg0MTViL3RhYmxlOjE0MzBhZmRkZmVhOTQ1NDc4N2Q1MTg2OTNhMzdhZTA4L3RhYmxlcmFuZ2U6MTQzMGFmZGRmZWE5NDU0Nzg3ZDUxODY5M2EzN2FlMDhfMi0xLTEtMS05MzA5OQ_407af4f8-c663-4e53-9fe0-6db92e1538a7"
]

And here are the ids for run two:

[
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfMTEtMS0xLTEtOTMwOTk_bbc2b7b1-32ed-48d5-a527-b7d6f9958bac",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfMTEtMy0xLTEtOTMwOTk_b3123b53-993e-4f4f-b7b6-dffd182a3b6a",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfMTEtNS0xLTEtOTMwOTk_453e463c-46ca-4fd4-863c-d372411602aa",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfMTEtNy0xLTEtOTMwOTk_11fd580c-a27b-4880-ae0d-1ff3e57aa251",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfNy01LTEtMS05MzA5OQ_cc16fa68-86d2-483d-b138-edeaaae1670d",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfNy03LTEtMS05MzA5OQ_4bbc98be-806c-4bdf-b4c2-bd8ac26ab6cf",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfNy0xLTEtMS05MzA5OQ_c5ea3522-659e-426d-8097-9d7b4124ec51",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl83My9mcmFnOmViNzcyZmU1NzQxOTQzNTVhOGZjYjAxZDdhOGJlYjIwL3RhYmxlOjM5NGU5YTIxODNmNTQ5Y2Q5MWVhNDZmNjRlNmYyNThhL3RhYmxlcmFuZ2U6Mzk0ZTlhMjE4M2Y1NDljZDkxZWE0NmY2NGU2ZjI1OGFfNy0zLTEtMS05MzA5OQ_661b1621-f87a-4e6d-b978-3e26adce211e",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl8xOS9mcmFnOmMyODhkYWExMjgxNzRiZmI4ZGVmMDAxMDgzNzM3ZTMyL3RhYmxlOjljMTk4NzkzMjBlNjQzOWM4YjliN2QzYzYwZGMwMGViL3RhYmxlcmFuZ2U6OWMxOTg3OTMyMGU2NDM5YzhiOWI3ZDNjNjBkYzAwZWJfMTQtMS0xLTEtOTMwOTk_b92e8df5-8dd1-43c5-b995-05d8fbb8e529",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl8xOS9mcmFnOmMyODhkYWExMjgxNzRiZmI4ZGVmMDAxMDgzNzM3ZTMyL3RhYmxlOjljMTk4NzkzMjBlNjQzOWM4YjliN2QzYzYwZGMwMGViL3RhYmxlcmFuZ2U6OWMxOTg3OTMyMGU2NDM5YzhiOWI3ZDNjNjBkYzAwZWJfMTQtMy0xLTEtOTMwOTk_c4dbac54-ef55-4a9f-846e-401873eec0cd",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl8xOS9mcmFnOmMyODhkYWExMjgxNzRiZmI4ZGVmMDAxMDgzNzM3ZTMyL3RhYmxlOjljMTk4NzkzMjBlNjQzOWM4YjliN2QzYzYwZGMwMGViL3RhYmxlcmFuZ2U6OWMxOTg3OTMyMGU2NDM5YzhiOWI3ZDNjNjBkYzAwZWJfMTQtNS0xLTEtOTMwOTk_a5608b5f-25d0-4ca0-aba3-83cd3757c214",
    "id3VybDovL2RvY3MudjEvZG9jOjk4YWIxYzMyMDg3YTQ3MzZhMzkyZDVjYTRkNDM0YWRiL3NlYzo5OGFiMWMzMjA4N2E0NzM2YTM5MmQ1Y2E0ZDQzNGFkYl8yMi9mcmFnOmQxMDA4OWM4OGUzNTQ2MmY4YTgwMjBiYWI3Mjg0MTViL3RhYmxlOjE0MzBhZmRkZmVhOTQ1NDc4N2Q1MTg2OTNhMzdhZTA4L3RhYmxlcmFuZ2U6MTQzMGFmZGRmZWE5NDU0Nzg3ZDUxODY5M2EzN2FlMDhfMi03LTEtMS05MzA5OQ_4520032a-25ba-45f8-81ff-11c1f7e0612b"
]

If you look at the ids at the bottom they are not the same. Is there a limit to the number of results returned so that I am getting a subset of max len 12 on each run?

I should say that the reason I am doing this is to collect the summation relationships for all elements in a particular table, so I was relying (maybe mistakenly) on the ids to filter out results whose ids are not in a particular table (not in any of the ix:nonfraction elements).

Thanks again for all the help, I know I am asking a lot of questions!

BrittMcDanel commented 1 year ago

Ah, I found the answer. I needed to specify --xule-include-dups.