...
| Code Block | ||
|---|---|---|
| ||
SELECT substring((({tenant}_mod_inventory_storage.instance.jsonb)->'title')::TEXT from 2 for 4),ARRAY_AGG({tenant}_mod_inventory_storage.instance.id)
FROM {tenant}_mod_inventory_storage.instance
INNER JOIN {tenant}_mod_inventory.records_instances
ON {tenant}_mod_inventory_storage.instance.id = {tenant}_mod_inventory.records_instances.instance_id
INNER JOIN {tenant}_mod_source_record_storage.raw_records_lb
ON {tenant}_mod_inventory.records_instances.record_id = {tenant}_mod_source_record_storage.raw_records_lb.id
group by substring((({tenant}_mod_inventory_storage.instance.jsonb)->'title')::TEXT from 2 for 4)
having count(1) > 3 and count(1) < 10; |
Item Record Operations (IRO)
The following data files are needed to support the Jmeter script during its execution.
- IRO_search_items.csv: a list of instance hrids for Search field that will be used to execute the script.
- IRO_search_items_delete.csv: a list of instance hrid for Search field that will be used to execute delete and edit operations in the script.
Retrieving Instances and Holdings (RIH)
- RIH_instance_ids.csv contains instance ids
View Bib (VB)
- VB_keywords.csv (contains keyword) in this case it is searching Instance by a keyword.
("aab",5
"aabe",2
"AAC",4
"AACE",2)
| Code Block | ||
|---|---|---|
| ||
SELECT substring((({tenant}_mod_inventory_storage.instance.jsonb)->'title')::TEXT from 2 for 4),LEAST((count(1)-2),5)
FROM {tenant}_mod_inventory_storage.instance
INNER JOIN {tenant}_mod_inventory.records_instances
ON {tenant}_mod_inventory_storage.instance.id = {tenant}_mod_inventory.records_instances.instance_id
INNER JOIN {tenant}_mod_source_record_storage.raw_records_lb
ON {tenant}_mod_inventory.records_instances.record_id = {tenant}_mod_source_record_storage.raw_records_lb.id
group by substring((({tenant}_mod_inventory_storage.instance.jsonb)->'title')::TEXT from 2 for 4)
having count(1) > 3 and count(1) < 10; |
View Holdings (VH)
- VH_keywords.csv (contains keyword) in this case it is searching Holdings by a keyword.
(0,5
00,5
00000,5
000000,5)
| Code Block | ||
|---|---|---|
| ||
SELECT substring((({tenant}_mod_inventory_storage.holding_records.jsonb)->'title')::TEXT from 2 for 4),LEAST((count(1)-2),5)
FROM {tenant}_mod_inventory_storage.holding_records
INNER JOIN {tenant}_mod_inventory.records_holdings
ON {tenant}_mod_inventory_storage.holding_records.id = {tenant}_mod_inventory.records_holdings.holdings_id
INNER JOIN {tenant}_mod_source_record_storage.raw_records_lb
ON {tenant}_mod_inventory.records_holdings.record_id = {tenant}_mod_source_record_storage.raw_records_lb.id
group by substring((({tenant}_mod_inventory_storage.holding_records.jsonb)->'title')::TEXT from 2 for 4)
having count(1) > 3 and count(1) < 10; |
View Instance Holdings Details (VIH)
No data preparation is needed.
Inventory Record Monitoring /View (VIR)
The following data files are needed to support the Jmeter script during its execution.
- VIR_instance_item.csv: a list of instance and item ids to run the script (could be not connected).
Invoices Operations (IO)
The following data files are needed to support the Jmeter script during its execution.
- IO_invoice_codes.csv: a list of keywords for searching invoices (the status of the invoiceÑ– should be open)
| Code Block | ||
|---|---|---|
| ||
SELECT {tenant}_mod_invoice_storage.invoices.jsonb->'vendorInvoiceNo'
FROM {tenant}_mod_invoice_storage.invoices limit 2000; |
- IO_organization_names.csv: a list of keywords for searching organization(only for create workflow)
| Code Block | ||
|---|---|---|
| ||
SELECT DISTINCT({tenant}_mod_organizations_storage.organizations.jsonb->'code')
FROM {tenant}_mod_organizations_storage.organizations limit 2000; |
Manage invoices GROUP/Approve invoices (AIE)
The following data files are needed to support the Jmeter script during its execution.
- invoice_codes.csv: a list of keywords for searching invoices (funds used in the invoice should be active and not used in FYR, the status of invoiceÑ– should be open, and invoiceÑ– should be with at least one invoice line)
| Code Block | ||
|---|---|---|
| ||
SELECT {tenant}_mod_invoice_storage.invoices.jsonb->'vendorInvoiceNo'
FROM {tenant}_mod_invoice_storage.invoices limit 2000; |