How to fetch the value from the table when the ref is enumlist?

[Manish_Jain11]

How to fetch the value from the table when the ref is enumlist ?

How to get the value in job_id column of the production from job_id column of the processes ?

Also how to build the related process list - REF_ROWS(“Processes” , ???)

[Aurelien]

HI @Manish_Jain1

Manish_Jain1:

How to get the value in job_id column of the production from job_id column of the processes ?

Not sure to understand. What about, in the table PRODUCTION, assuming [PROD_ID] is the key_column:

SELECT(PROCESSES[Job_ID],
  IN(    [_THISROW],    SPLIT(CONCATENATE([PROD_IDs])," , ")
))

About that:

Manish_Jain1:

Also how to build the related process list - REF_ROWS(“Processes” , ???)

I don’t get it.

[Manish_Jain11]

I am attaching the images of the table columns …see if that helps

[Aurelien]

Manish_Jain1:

How to get the value in job_id column of the production from job_id column of the processes ?

I think I was quite there, I adapted it.
Can you confirm the expression you want to build will be on the table “Production” ?
If so, can you let me know if that works ?

SELECT(Prod_Process[Job__File_Id],
  IN(    [_THISROW],    SPLIT(CONCATENATE([Production_IDs])," , "))
)

[Manish_Jain11]

Aurelien:

I don’t get it.

List of related processes . normally if the column containing ref is not an enum… It would be REF_ROWS(“prod_process”,”Production_Ids”). …but production_ids is an enum list with base type ref of production table… so how do I write this expression?

[Aurelien]

Manish_Jain1:

List of related processes . normally if the column containing ref is not an enum… It would be REF_ROWS(“prod_process”,”Production_Ids”). …but production_ids is an enum list with base type ref of production table… so how do I write this expression?

What about:

FILTER("Prod_Process",
  IN(    [_THISROW],    SPLIT(CONCATENATE([Production_IDs])," , "))
)

[Manish_Jain11]

FILTER(Prod_Process,IN([_THISROW],[Production_IDs]))

I am using this and it’s working fine but I felt that’s getting the app slow .

Can you think of my main problem on getting the job_id from prod_process table to production table

[Aurelien]

Manish_Jain1:

Can you think of my main problem on getting the job_id from prod_process table to production table

How to fetch the value from the table when the ref is enumlist? Questions

I think I was quite there, I adapted it. Can you confirm the expression you want to build will be on the table “Production” ? If so, can you let me know if that works ? SELECT(Prod_Process[Job__File_Id], IN( [_THISROW], SPLIT(CONCATENATE([Production_IDs])," , ")) )

[Manish_Jain11]

Thanks Aurelien . Just in time . I have done the following and it seems working . Since I am already filtering the Prod_PRocess in my Related Processes Column, I am not using the Prod_Process Column again and instead have used related processes …

Column - Related Processes

FILTER(Prod_Process,IN([_THISROW],[Production_IDs]))

Column - Job_ID

Any(Select([Related Processes][Job_File_Id],IN([_THISROW],[Production_IDs])))

But I am wondering if I can simplify both these expressions further to make the app faster. ?

How to fetch the value from the table when the ref is enumlist?:

Can you confirm the expression you want to build will be on the table “Production”

Yes.

[Aurelien]

Manish_Jain1:

I am wondering if I can simplify both these expressions further to make the app faster. ?

Because FILTER and SELECT run on a whole table, the only way I see to make the app faster, is to use a slice, or even more a security filter, in order to “shorten” the table.
… This is the best idea I have in mind.

[Manish_Jain11]

Ok . Let me check on that .