That won't work, because the filter would get rid of the parts below the top level. It would work for the job, since the job number is the same for all of them, but the parent part only shows up at the top level record. That filter would remove the lower levels from the results.
Maybe I can figure out a way to have the top level part show up on all levels of the table. Then I could filter it that way I guess. Any suggestions on how I would do that?
Let's see if any of you can figure out an elegant solution for this request.
I want to make a dashboard that creates a visual check to see if every operation before the requested part is completed. Basically a quick check to make sure all of the operations are reported and if you should have all of your parts to be able to start.
This is easy enough to do with a complete job, because I can take the job and all of the assembly numbers with their operations and use view rules to highlight done or not. I can get this to show up in one "column" of the related info. See below for a simple example of some of the info that I have on there.
headers job no; assy seq; part no ; op seq ; completed example row 12345;1,123-1-123,10,true
I can do this by job number and sort it by assembly sequence to get a check list that runs relatively in order so you could what is done and what is not. Since I just have every operation on the job, I only need to filter by job.
The next level that I want to take the to is to pick a specific assembly in this list and display the same information but only for the parts that are below that assembly. So for example, a welder (or his supervisor) wants to know if all of his parts are done for the weldment so he knows before he starts to gather the parts and start working. I would like to blow through all of the way to the bottom level instead of just one level down if possible.
I know that I can link 2 (or more) versions of the JobAsmbl table where I link the PartNum field to the Parent, however then I need to create a second (or more) column of data so instead of my list going from top to bottom, there is now a left to right component and it makes the results confusing, not to mention the query takes a long time to run.
Does anyone know of a way to filter so that I only have one column group of data but it still will grab all of the parts below the specified assembly? There has to be a creative way to use some sub queries to make this work.
<div>
<p>Let's see if any of you can figure out an elegant solution for this request.<br><br>I want to make a dashboard that creates a visual check to see if every operation before the requested part is completed. Basically a quick check to make sure all of the operations are reported and if you should have all of your parts to be able to start.<br><br>This is easy enough to do with a complete job, because I can take the job and all of the assembly numbers with their operations and use view rules to highlight done or not. I can get this to show up in one "column" of the related info. See below for a simple example of some of the info that I have on there.<br><br>headers<br>job no; assy seq; part no ; op seq ; completed<br>example row<br>12345;1,123-1-123,10,true<br><br>I can do this by job number and sort it by assembly sequence to get a check list that runs relatively in order so you could what is done and what is not. Since I just have every operation on the job, I only need to filter by job.<br><br>The next level that I want to take the to is to pick a specific assembly in this list and display the same information but only for the parts that are below that assembly. So for example, a welder (or his supervisor) wants to know if all of his parts are done for the weldment so he knows before he starts to gather the parts and start working. I would like to blow through all of the way to the bottom level instead of just one level down if possible.<br><br>I know that I can link 2 (or more) versions of the JobAsmbl table where I link the PartNum field to the Parent, however then I need to create a second (or more) column of data so instead of my list going from top to bottom, there is now a left to right component and it makes the results confusing, not to mention the query takes a long time to run.<br><br>Does anyone know of a way to filter so that I only have one column group of data but it still will grab all of the parts below the specified assembly? There has to be a creative way to use some sub queries to make this work.<br><br>Brandon<br></p><p><span><br></span></p><p></p>
</div>
<div style="color:#fff;min-height:0;"></div>
We are on E-10. Do you have an example of how to create the CTE? The description in help looks like it's something that will do what I want, but It doesn't give any examples on how to set it up and I have never used it before.
<div>
<p>We are on E-10. Do you have an example of how to create the CTE? The description in help looks like it's something that will do what I want, but It doesn't give any examples on how to set it up and I have never used it before.</p>
</div><span class="ygrps-yiv-2142476865">
<div style="color:#fff;min-height:0;"></div>
You could, but it would be a lot of clicks to make it work. Basically you would have a BAQ for one level, then you could add the same BAQ with a subscription to get another level down, and repeat for each level. But if you had multiple sub assemblies, you would have to click through each sub in order look through them all. It would be tedious to click through and easy to miss something. Still better than physically looking for the parts, but I think I can do better. My goal is to look through one strip of green if you are good to go, or a couple of red squares telling you which parts are missing. I'm trying to make a quick visual dashboard.
I'm working through the CTE like Jose suggested, as I think that will do what I want, I just have to do some learning.
I have it working. Now I want to put it into a dashboard. I works with the parameter setting, but I would like to subscribe to get the job number and parent part number. Is it possible to subscribe parameters in a dashboard?
<div>
<p>I have it working. Now I want to put it into a dashboard. I works with the parameter setting, but I would like to subscribe to get the job number and parent part number. Is it possible to subscribe parameters in a dashboard?</p>
</div><span class="ygrps-yiv-354316031">
<div style="color:#fff;min-height:0;"></div>
