Store case_id as hidden value

Users
1

I want to simplify my relational joins. Is it possible to store a record's
case_id as a hidden value? - Rob

2

Hey Rob,

I think that the Case ID for the chosen case should automatically be
provided in data exports (and can be found if you download a form via our
API) - is there something else you're trying to access?

Thanks,
Sheel

··· On Fri, Sep 4, 2015 at 12:56 PM, Rob wrote:

I want to simplify my relational joins. Is it possible to store a record's
case_id as a hidden value? - Rob

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah

3

Yes I'm trying to load the parent case_id into the child table so I don't
have to download a separate lookup table to join the two. Maybe I'm missing
something basic - Rob

4

Hi Rob,

How are you using lookup tables in this scenario? From the conversation so
far it sounds like you are working with data exports with the form data
that you've entered so far. If you are using lookup tables for this
configuration, please let us know some details about your setup so that we
might be able to advise you further.

Thanks,

··· -- Nate Haduch

Technical Support Analyst
Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139

On Fri, Sep 4, 2015 at 9:35 AM, Rob iotc2000@gmail.com wrote:

Yes I'm trying to load the parent case_id into the child table so I don't
have to download a separate lookup table to join the two. Maybe I'm missing
something basic - Rob

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

5

Hey,

I think Rob is referring to using Excel based lookups to match the list of
cases in one sheet to the other exported sheet which lists cases + their
parent case IDs.

Rob, can you file a UV ticket about having the parent_case_id directly
available in any case data exports? Unfortunately, I don't think there's an
easy way to do what you want to achieve for now, but we can certainly try
to improve this workflow.

Thanks,
Sheel

··· On Wed, Sep 9, 2015 at 11:23 AM, Nate Haduch wrote:

Hi Rob,

How are you using lookup tables in this scenario? From the conversation so
far it sounds like you are working with data exports with the form data
that you've entered so far. If you are using lookup tables for this
configuration, please let us know some details about your setup so that we
might be able to advise you further.

Thanks,

--
Nate Haduch

Technical Support Analyst
Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139

On Fri, Sep 4, 2015 at 9:35 AM, Rob iotc2000@gmail.com wrote:

Yes I'm trying to load the parent case_id into the child table so I don't
have to download a separate lookup table to join the two. Maybe I'm missing
something basic - Rob

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah

6

Nate and Sheel thanks - Sheel yes that is what I am wanting to do. I will
try the UV ticket though its not urgent. I was also wondering if case_id is
only created after the record is uploaded to the server. Rob

7

Hey,

Nate and Sheel thanks - Sheel yes that is what I am wanting to do. I will

try the UV ticket though its not urgent. I was also wondering if case_id is
only created after the record is uploaded to the server.

Case ID is set by the phone so should be available as soon as the case is
created.

··· > Rob > > -- > You received this message because you are subscribed to the Google Groups > "commcare-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to commcare-users+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. >