Skip to main content

Hi all,

Is there anywhere in the database where I can find these 2 values?

 

I’m not sure if the System Info plugin shows info for dialogs, but you can try.

RMB on the bottom toolbar to show it, then click in a field.


Looking at the code the values are hardcoded to 1 in the client if you open the dialog from places like “Inventory Part In Stock”, “Receive inventory Part” etc.

That means that you can not change the values.


Ok, I did not make myself clear.

I am not looking for the default values, but values the user type in when printing the labels. 

Her is some horrible code that nearly do it. There most be a cleaner way?

select 
print_job_api.Get_User_Name(con.print_job_id) as user_name,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINED1]/ORIGIN_PACK_SIZE/text()') as pack_size,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINED1]/PART_NO/text()') as par_no,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINED1]/LOT_BATCH_NO/text()') as lot_batch_no,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINED1]/WAIV_DEV_REJ_NO/text()') as waiv_dev_rej_no,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINED1]/CONFIGURATION_ID/text()') as configuration_id,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINED1]/PROJECT_ID/text()') as project_id,
extractvalue(xmltype(xmlData.data), '//BARCODE_LINES/BARCODE_LINED1]/SERIAL_NO/text()') as serial_no,
regexp_substr(client_sys.Get_Key_Reference_Value(con.instance_attr,'OPTIONS'),'\d+') as no_of_copies,
regexp_count(data, '?</BARCODE_ID>?') as no_of_labels_in_total
from print_job_contents con inner join xml_report_data xmlData on con.result_key= xmlData.result_key
where con.result_key= 95680


Aha, you need to se the parameters the user entered.

Here is another SQL you can use:

SELECT MIN(origin_pack_size) pack_size,
COUNT(DISTINCT barcode_id) number_of_labels,
COUNT(*) / COUNT(DISTINCT barcode_id) number_of_copies
FROM inventory_part_barcode_rep
WHERE result_key = 15503

Since the pack size is same on all lines in the report you can use min or max to get one of them.


inventory_part_barcode_rep... just in front of me :confounded:

Thanks.